Differentiate between a collapsed v/s expanded row in a Matrix visual in a Measure

[adityalele]

In a matrix visual I have two fields in the Row header column creating nested rows.
For the values, I want to pick Measure1 when collapsed and Measure2 when expanded.

[mwegener · Accepted solution]

Hi @adityalele ,

You can check in a measure if the field of the second level is filtered and return the value of measure 1 or 2 depending on it.

https://docs.microsoft.com/de-de/dax/isfiltered-function-dax