I try an If function and it seems I am missing a very basic point.
The IF function is in the calculated column 'FilteredLevel' and referes to a calculated measure:
Since LevelH1 is not "L5" I expext to get "NO". The formula is not working as expected. What am I missing?
the formula is
LevelH1:= VAR Lvl=
IF ( ISFILTERED ( [Level5] );
I have a hierarchy with 8 levels. What I want to achieve is a column with the childs of the selected parent. E.G. if Level5 is selected the calculated column should display all members of Level6.
if you are just looking at this in raw data then it's not currently filtered - what results do you get if you add the columns into a table within powerbi, ensuring you pull through the columns you are checking to see if they are filtered?
you'll probably need to change the filteredlevel to a measure as well as calculated columns are only calculated the once. they do not get re calculated by filter changes.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.