Display percentage of bar chart in Card based on filter

[bw70316]

I have a graphic of counts per age via zip code and I was hoping to be able to display a % based on the selected zip code. For example, 87 kids aged 4-7 with 14 of them residing in zip code 27704. How do I display 14/87 as a % so that regardless of the zip code I click on, I am provided with the % of kids who are aged a certain age? Thanks in advance

[v-yuta-msft · Accepted solution]

@bw70316 ,

You may create a measure using dax like pattern below:

Percentage =
COUNT ( Table[kids] ) / CALCULATE ( COUNT ( Table[kids] ), ALL ( Table ) )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bw70316]

Thanks, I have meetings all morning but will try this solution this afternoon and accept your solution if it is a workable solution. Thanks again for the reply.

[amitchandak]

Create one measure that excludes those filter which you do not want denominator to consider. Except clause can be used for that.

Divide it by the numerator that considers other filters.