Is possible to make Matrix data change when expand rows?

[AndreDeLuca]

I have a matrix where i accumulate projects inside of departments (rows), and my values are dates and text information, wich does not make sense to show if i have my projects hidden inside of the departments.
My question is, is it possible not show the information on the values field when everything is collapsed?

[dk_dk · Accepted solution]

Hi @AndreDeLuca ,

You can achieve this by creating mesures with ISINSCOPE.

Lets say you only want to show Responsável when the Area is expanded. Let's assume the level under Area is called SubArea.

You can then write something like this:

Responsável Measure =

IF(ISINSCOPE(Table[SubArea]),MIN(Table[Responsável]),"")

Then instead of using the Responsável column in your matrix, use the measure.

Let me know if you run into any issues. You can find more info on how ISINSCOPE works here and here.