Change values from matrix table

[Anonymous]

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!

[v-piga-msft]

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

[parry2k]

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

[Anonymous]

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

I'm not using measures on this visualization.

[parry2k]

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

[Anonymous]

I read the article, but how can I do that do my data since is not a measure?

I mean, only repeated the values, because that field (column) don't exist in the table that I relationed with each other.

[v-piga-msft]

Hi @Anonymous ,

Have you solved the problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please free to ask.

Best  Regards,

Cherry

[Anonymous]

Actually, my values is coming from a cube, so that value it doesn't have in that field from hierarchy, that's why keeps repeating.

So, I think I shouldn't had open this question. How do I close?