User Profile
Georg
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
Re: IF Function not working
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, GeorgIF Function not working
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,
