Forum Discussion

Ashish9201's avatar
Ashish9201
Helper I
4 years ago
Solved

Multi Select Issue in Slicer created using measure

Hi,   I am unable to select multiple option in slicer. Can someone help me in resolving multi select error while selecting slicer. I am not sure how to use All selected here. Below is the DAX for ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Ashish9201 , Try like

     

    ARPE Tiers Filter =
    VAR CurrentSelection = values( 'ARPE Tiers'[ARPE Tiers] )
    VAR CurrentStatus = msdyn_timeentry[ARPE Tiers]
    RETURN
    SWITCH (
    TRUE (),
    CurrentStatus in CurrentSelection = , 1,
     "All" in CurrentSelection , 1,
    0)

amitchandak's avatar
amitchandak
Super User
4 years ago

Ashish9201 , Try like

 

ARPE Tiers Filter =
VAR CurrentSelection = values( 'ARPE Tiers'[ARPE Tiers] )
VAR CurrentStatus = msdyn_timeentry[ARPE Tiers]
RETURN
SWITCH (
TRUE (),
CurrentStatus in CurrentSelection = , 1,
 "All" in CurrentSelection , 1,
0)