How to work with hierarchical data?

Clara,

I create the following measures in the table. Then I set the value of Measure to 0 in visual level filter. If the DAX don't return your expected result, please post your desired result here.

chk1 = var maxvalue= CALCULATE(MAX(Table2[value]),ALLEXCEPT(Table2,Table2[level1dec])) return IF(maxvalue=MAX(Table2[value]),1,0)

chk2 = CALCULATE(COUNTA(Table2[level1dec]),ALLEXCEPT(Table2,Table2[level1dec]))

Measure = IF([chk1]=1 && [chk2]>1,1,0)

Regards,
Lydia

Okay! Here's what I came up with:

chk3 = VAR level2 = SUMX('Table1','Table1'[level2])
RETURN IF(ISBLANK(level2),1,0)

Measure = IF([chk1]=1 && [chk2]>1 && [chk3]=1,1,0)

This is possibly not the most efficient solution, but it worked in my case :) Please let me know if there is a smarter way to do it!