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" )
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.