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
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

AgeOfEgos,

 

There is another slicer. Just use ALL ( Sheet1 ).

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

That did work as a test--but I need the date slicer to still effect that total.  Just not the service slicer