Forum Discussion

AgeOfEgos's avatar
AgeOfEgos
Icon for Helper I rankHelper I
7 years ago
Solved

Distinct Count with ALL function to ignore slicer not working

I have a slicer that has a drop down of possible services a patient will receive.  I have a measure that counts ALL patients regardless of service, then another measure that counts only the selected ...
Need Help
NAOS's avatar
NAOS
Icon for Advocate III rankAdvocate III
7 years ago

Hi,

Easiest way to solve it is to create a calendar table and use that as your report slicer. You will also have to create tables for other attributes when necessary. DAX is powerful but needs a good data model in behind to work in a more predictable way.

And use this measure. 

ALLPATIENTS = CALCULATE(DISTINCTCOUNT(Sheet1[Name]),ALL(Sheet1))

That should do.

Kind regards,