Only keep the value of the highest hierarchy in matrix chart

[JaysYee]

Hi,

How do I only show the value of the highest hierarchy in a matrix chart even when expanded?

For example, I have the following data.  How do I hide the No/Yes for the subcategories?  I tried to use "ISINSCOPE" without success.

Parent Category	SubCategory	Yes/No	Dollars
Parent 1	SubCat1	No	...
Parent 1	SubCat2	No	...
Parent 2	SubCat1	Yes	...
Parent 2	SubCat2	Yes	...
Parent 3	SubCat3	Yes	...

[Shravan133 · Accepted solution]

Hi,

Can you please show us how ypu have used ISINSCOPE()?

try this:

DisplayYesNo =
IF(
ISINSCOPE('YourTable'[Parent Category]) && NOT ISINSCOPE('YourTable'[SubCategory]),
SELECTEDVALUE('YourTable'[Yes/No]),
BLANK()
)

[Ashish_Mathur]

Hi,

Try this measure

Measure = if(hasonevalue(Data[Sub category]),blank(),[your measure])

Hope this helps.

[danextian · Accepted solution]

Hi @JaysYee ,

Please try this:

[Shravan133 · Accepted solution]

Hi,

Can you please show us how ypu have used ISINSCOPE()?

try this:

DisplayYesNo =
IF(
ISINSCOPE('YourTable'[Parent Category]) && NOT ISINSCOPE('YourTable'[SubCategory]),
SELECTEDVALUE('YourTable'[Yes/No]),
BLANK()
)