Forum Discussion

vin26's avatar
vin26
Resolver I
3 years ago

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 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:

General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • vin26's avatar
    vin26
    Resolver I
    3 years ago

    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:

     

  • vin26's avatar
    vin26
    Resolver I
    3 years ago

    HI Team,

     

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