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 >.
Thank you johnt75, it makes sense. Do you think there is a dax expression which would work in this case? I found out that I can use a visual calculation and hide both the columns BD and RD by slicing them. I believie this is not so clean solution as this is only a small pattern that I am showing. I just wonder, if dax can handle this by not comparing blank values?