Sliced Count of Total Count

[MichaelG_NAC]

Hello 

I am looking to create a measure which shows a count which can be sliced divided by the original count 

Something along the lines of 

Measure = A/B

Where A is the count which has been changed by the slicers and where B is the original count before the slicers 

I think the FILTER(ALL()) Function would be used but so far has not worked 

[Anonymous · Accepted solution]

Hi michael,

Measure a is just:

CountSlicer = COUNT("what you want to count")

and measure b is:

CountBeforeSlicer = CALCULATE([a],ALL("Table used for count"))

That should do the trick. If it does not work can you post some sample data and be more specific with your current and expected results?