Forum Discussion
Georg
9 years agoFrequent Visitor
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...
Dog
9 years agoResponsive Resident
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
9 years agoFrequent Visitor
Hi,
while LevelH1 is changing according to the selected level, FilteredLevel remains unchanged.
kind regards,
Georg
- Dog9 years agoResponsive Resident
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