Forum Discussion
Solved
Strange DAX evaluation context
Hi community, I have been trying to figure it out for a while but with no success. I have an easy table where one IA has many types and I want to calculate only one type based on numbers. In ...
I think you can combine the >= with a check for NOT ISBLANK()
Type calculated = IF ( NOT ISBLANK ( [RD] ) && [RD] >= [BD], "Rodinny dum" )
When you change the condition to >= the extra row which appears shows blank for both [RD] and [BD]. As blank = blank [Type calculated] returns the value, rather than returning blank as it did when you had the condition as >.