Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |