Forum Discussion

agur's avatar
agur
Icon for Advocate I rankAdvocate I
8 years ago
Solved

DAX ALL respect slicer

I have a report with page level filter "Last 12 calendar months" I have a slicer which filters on a field called Department I have a calculated column which looks like this: ActualCloseMonth12Mont...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    You can try and replace ALL(Oprtunities) with ALLEXCEPT(Opprtunities[Department])

Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

You can try and replace ALL(Oprtunities) with ALLEXCEPT(Opprtunities[Department])

agur's avatar
agur
Icon for Advocate I rankAdvocate I
8 years ago

Thank you!

You managed to help and make me feel stupid with one sentence :smileyhappy: