cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MichaelG_NAC Frequent Visitor
Frequent Visitor

Sliced Count of Total Count

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Jeltex Member
Member

Re: Sliced Count of Total Count

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?

1 REPLY 1
Jeltex Member
Member

Re: Sliced Count of Total Count

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?