Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Change values from matrix table

Hi!

 

I've got a matix table that I'd like to "erase" the values that are red and keep only the green values.

I'd like to do that for all columns, not to keep the repeated values, only the total.

 

 

Thanks!

Need Help
Tips and Tricks
Tutorial Requests

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous you need to give more context, is this a measure? You can use InScope function 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This this is a fact and all the columns on the left is dimensions.

      I'm not using measures on this visualization.

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous create a measure and IsInScope function, hope this post help you

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    6 years ago

    Hi Anonymous ,

    If I understand your requirement correctly that you only want to show the total row in matrix.

    If so, what about adding the +/- icons for row header and then clik + to achieve your desired output?

    If not, please describe your scenario in more details.

    Best  Regards,

    Cherry