Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How we can select multiple filter in measure slicer

Hello Mates,

Hope everyone's doing well.

 

I have one requirement where I want to select multiple measures from Slicers selection. For that I have create the belo tables and Dax.

But I am not able to select it and its throwning me below error msg.

 

Measure Selection = SWITCH( TRUE(),
    VALUES(DimMeasure[Measure]) = "Last 7 Days", [Clicks Last 7 Days],
    VALUES(DimMeasure[Measure]) = "Last 30 Days", [Clicks Last 30 days],
    VALUES(DimMeasure[Measure]) = "Last Quarter", [Clicks Last Quarter Days],
VALUES(DimMeasure[Measure]) = "Previous Period", [Clicks Previous Period],
VALUES(DimMeasure[Measure]) = "Same Period Last Year", [Clicks Same Period Last Year],
    BLANK())
 

So please help looking for urgent help !
Thank you in advance.

 

Regards,

Dev

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , what should happen when you select two values?? You should consider only one

    Measure Selection = SWITCH( TRUE(),
    MAX(DimMeasure[Measure]) = "Last 7 Days", [Clicks Last 7 Days],
    MAX(DimMeasure[Measure]) = "Last 30 Days", [Clicks Last 30 days],
    MAX(DimMeasure[Measure]) = "Last Quarter", [Clicks Last Quarter Days],
    MAX(DimMeasure[Measure]) = "Previous Period", [Clicks Previous Period],
    MAX(DimMeasure[Measure]) = "Same Period Last Year", [Clicks Same Period Last Year],
    BLANK())

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey amitchandak 

       

      Thank you for your quick reply.

       

      Here, I want to show atleast two comparision by selecting two slicer filter. So is this possible ?

       

      Thanks,

      Devanand

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

    Switch function is possible to setting multiple cases to return different expressions. (these expressions can from different measures) Notice: it not able to handle summarize results such as selecting multiple conditions at the same time. (for this scenario, it not trigger any conditions)

    If your scenario requires to handle multiple selections, I think you need to do some modifications with summarized row contents.

    Regards,

    Xiaoxin Sheng