How we can select multiple filter in measure slicer

[Anonymous]

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

[v-shex-msft]

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

[amitchandak]

@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]

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