Condition that checks if a matrix is collapsed, in order to display column data dynamically?

[Anonymous]

Hi everyone, I am fairly new to PowerBI but I have been enjoying my learning experience so far. I have been stuck on a problem though and was hoping someone might have any ideas.

I have an Excel with 4 columns (this is all test data):

1. Category
2. Sub-Category
3. Description
4. Sub-Category Description

I have the data displayed in a matrix visual that has the ability to collapse the Categories into their respective Sub-Categories. I am trying to figure out how to have just one "Description" column that:

1. When uncollapsed (Category level), shows the "Description"
2. When collapsed (Sub-Category level), shows the "Sub-Category Description".

I was hoping that there would be an "isCollapsed" type condition I could use but I could not find a solution to this. 

Thanks so much in advance to any help.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Please create a measure like below and put it into "Values" of Matrix.

Measure =
IF (
    HASONEVALUE ( 'Table'[Sub-Category] ),
    MAX ( 'Table'[Sub-Description] ),
    IF ( HASONEVALUE ( 'Table'[Category] ), MAX ( 'Table'[Description] ), "NULL" )
)

[Anonymous]

Thanks so much! This is exactly what I was trying to figure out.