Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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-Group-Cluster-Column-It-Works-Until-a-Filter-is/...
I have changed my measure to:
Cust% = VAR _catTot = CALCULATE ( DISTINCTCOUNT ( 'Combined'[Shipment EXTERNAL ID] ), FILTER ( ALL ( 'Combined' ), 'Combined'[Destination Contact Name] = SELECTEDVALUE ( 'Combined'[Destination Contact Name] ) ) ) RETURN DIVIDE ( DISTINCTCOUNT ( 'Combined'[Shipment EXTERNAL ID]) , _catTot ) + 0
It still seems as though the denominator is not changing according to filter/slicer selections.
Any help on this would be greatly appreciated.
Thanks.
Solved! Go to Solution.
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 ) + 0
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi @Anonymous
Can you share the pbix? or a simplified version that reproduces the problem?
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!
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 ) + 0
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Amazing, thank you so much!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |