Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filtering a matrix visual by measures

I am trying to filter a matrix visual by the measures within that visual. Here is what the matrix currently looks like: matrix Each of the matrix values are individual measures. I would like to be a...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Anonymous ,

     

    If you want to display  the values of one measure in matrix by default, it will be implemented.  I modify the formula you can reference.  However if to display the values of all the measures, I’m afraid it will not be implemented.

    Measure 2 =
    SWITCH (
        SELECTEDVALUE ( Table2[Index] ),
        1, [Ttl],
        2, [POD],
        3, [GP],
        [Ttl]
    )
    you can change the default measure of Ttl to what you want.

     

    Best Regards,

    Xue Ding 

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

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Anonymous ,

 

If you want to display  the values of one measure in matrix by default, it will be implemented.  I modify the formula you can reference.  However if to display the values of all the measures, I’m afraid it will not be implemented.

Measure 2 =
    SWITCH (
        SELECTEDVALUE ( Table2[Index] ),
        1, [Ttl],
        2, [POD],
        3, [GP],
        [Ttl]
    )
you can change the default measure of Ttl to what you want.

 

Best Regards,

Xue Ding 

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

 

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    Hi Anonymous ,

    Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

     

    Best Regards,

    Xue

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