Percent By Group - Cluster Column - Denominator Not Calculating Properly

[Anonymous]

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.

[AlB]

Hi @Anonymous 

Can you share the pbix? or a simplified version that reproduces the problem? 

[Anonymous]

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 · Accepted 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  

[Anonymous]

Amazing, thank you so much!