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 reference. Can someone help

 

ARPE Tiers Filter =
VAR CurrentSelection =
    SELECTEDVALUE ( 'ARPE Tiers'[ARPE Tiers] )
VAR CurrentStatus = msdyn_timeentry[ARPE Tiers]
RETURN
    SWITCH (
        TRUE (),
        CurrentSelection = CurrentStatus, 1,
        CurrentSelection = "All", 1,
        0
    )
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)

1 Reply

  • 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)