Forum Discussion
adityalele
Microsoft Employee
Microsoft EmployeeDifferentiate between a collapsed v/s expanded row in a Matrix visual in a Measure
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.
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
1 Reply
- mwegener
Most Valuable Professional
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