Forum Discussion

jankonas's avatar
jankonas
Advocate I
1 year ago
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 ...
  • johnt75's avatar
    johnt75
    1 year ago

    I think you can combine the >= with a check for NOT ISBLANK()

    Type calculated =
IF ( NOT ISBLANK ( [RD] ) && [RD] >= [BD], "Rodinny dum" )
jankonas's avatar
jankonas
Advocate I
1 year ago

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?

johnt75's avatar
johnt75
Super User
1 year ago

I think you can combine the >= with a check for NOT ISBLANK()

Type calculated =
IF ( NOT ISBLANK ( [RD] ) && [RD] >= [BD], "Rodinny dum" )
  • jankonas's avatar
    jankonas
    Advocate I
    1 year ago

    Works perfect. DAX evaluation with a blank value can be tricky. Thank you for the explenation and following solution.