DAX Measure help - how to total only items filtered

[BoundedInANutshell]

Hi,

I have the following measure which is used to dynamically switch between counts and percentages (using a slicer). However, when it is displaying percentages and the matrix is filtered with other slicers, the percentage calculation still uses the overall total, not the reduced (filtered) total - thus the overall column doesn't total 100% I know I need to change the division part (which is wrapped in the FORMAT) but what do I change it to so that the percentage calculation uses the reduced (filtered) total ?

Any help would be greatly appreciated.
Many thanks, Jason

PercentageViewToggle =
IF (
ISFILTERED ( 'SlicerDataViews'[View] ),
FORMAT( COUNT ( 'Enquiries'[RID] )
                / CALCULATE ( COUNT ( 'Enquiries'[RID] ), ALLEXCEPT ( 'Enquiries', 'Enquiries'[Enquiry Date] ) ),"0.0%"),
( COUNT ( 'Enquiries'[RID] )
))

 

[Matt Allington]

Try using allselected. This will allow the slicer to work, but percentages will show the total local to the internal visual

 

[BoundedInANutshell]

Hi Matt, Yes, that has worked a treat. One strange anomaly though, is my matrix shows rows with no data when the ISFLTERED condition is true and it displays percentages. But not when ISFILTERED is false. Any thoughts how I could fix this? I've tried adding a visual filter for IS NOT BLANK but that doesn't work.
Any help greatly appreciated (and thanks for the ALLSELECTED fix !)
Regards . . . Jason