Skip to main content

Hi all,

 

I'm creating a demographics dashboard.  the first view is a simple Gender breakdown, by count:

 

Dashboard Filter from a dimension to a measure (w/o parameters)?

The second view is a geographical map:

 

dash2.jpg

The functionality I'd like is to click on Female in the first dash, and update the geographical map to display a calculated field Female Percentage:

 

COUNT(IF [Gender]='Female' THEN [Gender] ELSE NULL END) / Count([Gender])

 

Likewise, when I click on Male, the geographic map should update to display Male Percentage:

 

COUNT(IF [Gender]='Male' THEN [Gender] ELSE NULL END) / Count([Gender])

 

I've tried to do this via another calculated field, Percentage Switch - Gender:

 

if ATTR([Gender]) = 'Male' then [Male Percentage]

elseif ATTR([Gender]) = 'Female' then [Female Percentage] END

 

But, as you might have guessed, this doesn't work, because it filters down to only male or female values, and shows all percentages as 100%.  Is there any way to accomplish this functionality, preferably without parameters?  Sample workbook attached.

3 answers
  1. Jul 13, 2016, 7:39 PM

    Makes perfect sense. Here's what we're looking at for a solution: 5 calculated fields is all we're gonna need. I've annotated each calculation to explain what they all do.

     

    Let me know if this is what you're looking for! I put together a combined dashboard as well, although you're action filter still works to switch from the Breakdown to the Map.

     

    Makes perfect sense. Here's what we're looking at for a solution: 5 calculated fields is all we're gonna need. I've annotated each calculation to explain what they all do.

0/9000