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,

 

If the field dragged to slicer comes from another table that has relationship to Sheet1, you may change it to ALL ( Table2[Service] ).

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

    Only one table in the file