Forum Discussion
Show the multiple measures value based on the filter selection
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 ...
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.