Forum Discussion
Percent By Group - Cluster Column - Denominator Not Calculating Properly
Hi All, I am having an continuing issue with grouping a cluster column chart and showing the percentages of each group. Original Post: https://community.powerbi.com/t5/Desktop/Percent-By-Grou...
Hi Anonymous
Try this modification to your measure:
Group% 2 = VAR _catTot2 = CALCULATE ( DISTINCTCOUNT ( 'Sample Data'[ID] ); ALL ( 'Sample Data'[Delivery Status] ) ) RETURN DIVIDE ( DISTINCTCOUNT ('Sample Data'[ID]); _catTot2 ) + 0Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hello, AlB.
Here is an example file, private information changed to generic with a date slider.
https://drive.google.com/open?id=1gha9eP4pfvip-CKcvayEyGHG42T9W8TP
You'll notice as you change the date, the percentages start calculating wrong.
Thanks!
AlB
Community Champion
Community ChampionHi Anonymous
Try this modification to your measure:
Group% 2 =
VAR _catTot2 = CALCULATE (
DISTINCTCOUNT ( 'Sample Data'[ID] );
ALL ( 'Sample Data'[Delivery Status] )
)
RETURN
DIVIDE ( DISTINCTCOUNT ('Sample Data'[ID]); _catTot2 ) + 0
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Amazing, thank you so much!