Change Measure based on tablix hierarchy

[MCacc]

Hello, 

I have a table where my Level 1 is > to my Level 2:

In my pbi I need to build a matrix visual where

1) At the Level 1 I need to return the MAX of the column value for the LEVEL 2

2) At Level 2 just returns the value ONLY of LEVEL 2

Meaning, something like that:

Can ISFILTERED help me?

Thank you for your help!

[amitchandak · Accepted solution]

@MCacc , Based on what I got

You need a measure like

Maxx(Values(Table[Level2]), calculate(Sum(Table[Value])))

[MCacc]

Amazing! It works just fine 

Thank you!