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

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

      and yeah I've tried ALLEXCEPT(Sheet1, Sheet1[Date]) but the moment I put an ALL or ALLEXCEPT back on that measure--it starts using the Service slicer again.