Waffle chart not considering the overall total but the count of values in the top most category

[Anonymous]

I have got multiple categories and the respective counts in a column,I need the waffle chart to display how much is contributed by each category.

For example,

Total = 15

A - 5

B - 4

C- 1

I should be able to display A-5/15*100,B- 4/15*100,C-1/15*100,but what I am getting here is 5/5,4/5/1/5,i.e., waffle chart automatically picks up the topmost category as the denominator and applies through out ,which is not correct.

How can I overcome this?

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on my research, I created data to reproduce your scenario.

Then you may create a measure as follows.

Percentage = 
DIVIDE(
    SUM('Table'[Counts]),
    CALCULATE(
        SUM('Table'[Counts]),
        ALLSELECTED('Table')
    )
)*100

Finally, you can put the measure to 'Values' area in 'Fields' ribbon. Here is the result.

Best Regards

Allan

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

[cschroy]

I can't thank you enough for this solution!! You have no idea how much time I spent trying to figure this out. Thnak you so much

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan