Show the multiple measures value based on the filter selection

[vin26]

Hello,

Please help me to get below issue resolved, I am looking for solution on the filter the measures which are having values when multiple slicer items are selected. Here is the example:

I have created 3 measures with multiple conditions and added a independent table for slicer to switch the measures. In below example when I select Measure 2 and Measure 3, the table should show both the measure having number 1, which are Product A, B and C. When Measure 1 and 2 are selected table should filter Product B, C and D. When all selected all the Product should get filtered.

Expected result:

[vin26]

HI Team,

I am yet to get solution for above query, any help on this would be appreciable.

[vin26]

Hi @Anonymous  Thanks a lot for the this solution. With this solution I have couple of challenges:
1. I don’t want to hide or disappear Measures which are not selected, but just have to filter only Products 

2. I have a few other columns/Measures (other than above 3 measure) as well, which I don’t want to show in slicers

Just wanted to filter Products where Measure 2 and Measure 3 values are 1

Here is expected result:

[Anonymous]

Hi @vin26,

I suggest you to create a measure name table and then create a matrix.

Measure = 
VAR _Measure1 = SUM('Table'[Value1])
VAR _Measure2 = SUM('Table'[Value2])
VAR _Measure3 = SUM('Table'[Value3])
RETURN
SWITCH(SELECTEDVALUE('Measure Name'[Measure]),"Measure 1",_Measure1,"Measure 2",_Measure2,"Measure 3",_Measure3)

Result is as below.,

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.