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
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

    • Dog's avatar
      Dog
      Responsive Resident
      9 years ago

      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