Forum Discussion
MCacc
Helper IV
Helper IVChange Measure based on tablix hierarchy
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!
MCacc , Based on what I got
You need a measure like
Maxx(Values(Table[Level2]), calculate(Sum(Table[Value])))
2 Replies
- amitchandak
Super User
MCacc , Based on what I got
You need a measure like
Maxx(Values(Table[Level2]), calculate(Sum(Table[Value])))
MCaccAmazing! It works just fine
Thank you!