Forum Discussion
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...
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi 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
Responsive Resident
Responsive ResidentHi 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