Forum Discussion

Herson's avatar
Herson
Regular Visitor
4 years ago
Solved

Ticky question regarding Filter/DAX/Slicer

Hi members,   I have a table where I need to use slice the Amount by industry/department/group. However, the tricky part is that when slicing Industry the amount has to be filtered by CATEGORY [CO...
DAX
Filter
Slicer
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    You can create SWITCH measure which changes calculation logic based on slicer selection. Here is an example of the logic:

    Measure =
    SWITCH(TRUE(),
    ISFILTERED(firstslicer),Measure1,
    ISFILTERED(secondslicer),Measure2)


    I hope this helps and if it does consider accepting this as a solution!
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

You can create SWITCH measure which changes calculation logic based on slicer selection. Here is an example of the logic:

Measure =
SWITCH(TRUE(),
ISFILTERED(firstslicer),Measure1,
ISFILTERED(secondslicer),Measure2)


I hope this helps and if it does consider accepting this as a solution!
Herson's avatar
Herson
Regular Visitor
4 years ago

Thank you ValtteriN for the suggestion!