Forum Discussion

Georg's avatar
Georg
Frequent Visitor
9 years ago

IF 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 L...
Need Help
Dog's avatar
Dog
Responsive Resident
9 years ago

Hi Georg

 

what's the formula behind measure [LevelH1]?

 

Thanks

 

Georg's avatar
Georg
Frequent Visitor
9 years ago

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

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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

    • Dog's avatar
      Dog
      Responsive Resident
      9 years ago

      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

      • Georg's avatar
        Georg
        Frequent Visitor
        9 years ago

        Hi,

        while LevelH1 is changing according to the selected level, FilteredLevel remains unchanged.

         

         

         

        kind regards,

        Georg