Matrix visual - remove value when matrix is drilled up and only show values when drilled down

[Anonymous]

Hi, 

I have a matrix visual and I want to remove the 'first' value when the visual is drilled up and only show the values when drilled down.

this is what my visual looks like currently. I want to remove the values un datasheet they only show when drilled down

I have tried a couple of DAX formulas but its not working for me.

[MFelix]

Hi @Anonymous ,

For this you need to do something similar to this:

DATASHEET = IF(ISINSCOPE(LowerLevel of matrix), min(Table[Value])

You need to replace the lowerlevel of matrix by the column you use on the drill down should do the work.