Matrix visual - Don't want the repeated values when drilling down

[Educate]

Hi,

I have a matrix that I created a measure for the values field and every row in the dropdown shows the same value until the next new amount. I only want the amount to show at the parent level. See below

Current

Parent1   Parent1Value
--Child1  Parent1Value
--Child2  Parent1Value
Parent2   Parent2Value
--Child1  Parent2Value

This is what I need from the matrix

Parent1   Parent1Value
--Child1  -blank-
--Child2  -blank-
Parent2   Parent2Value
--Child1  -blank-

[MFelix · Accepted solution]

Hi @Educate ,

You must use something similar to this:

Measure = IF(ISINSCOPE(Table[[Child]), Blank(), [Measure Value])

[MFelix · Accepted solution]

Hi @Educate ,

You must use something similar to this:

Measure = IF(ISINSCOPE(Table[[Child]), Blank(), [Measure Value])

[microsoftee]

Hi, your formula work to hide measure value while expand child rows but then the measure value completely disappear, it should showup in Row Header.

Any idea how can do that?

[Educate · Accepted solution]

Thank you soooo much. I read about the ISINSCOPE funtion but I was not able to get it to work until now. Thank you for the correct syntax.