Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Experts,
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?
kind regards,
Hi,
the formula is
LevelH1:= VAR Lvl=
IF ( ISFILTERED ( [Level5] );
"L5";
IF(ISFILTERED(ProfitCenterH1[Level4]);
"L4";"XXX"))
return Lvl
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.
kind regards,
Georg
Hi @Georg,
You use ISFILTERED function in the LevelH1 measure, how do you judge if there is a filter? I create the simple data, and use the similar measure, it always return XXX. Could you please share your .pbix for further analysis?
Best Regards,
Angelia
Hi George,
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?
Dog
Hi,
while LevelH1 is changing according to the selected level, FilteredLevel remains unchanged.
kind regards,
Georg
Hi George.
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.
Dog
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |