Forum Discussion

pmadam's avatar
pmadam
Icon for Helper II rankHelper II
6 years ago
Solved

Help division error

Hi All,   I am trying to divide two text columns for a particluar dimension. So i get error when the numerator or denominator has blank value. I went forward and added if clause as below but i stil...
Dax Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    pmadam Maybe:

    XY =
IF(
  ISBLANK([DSAM Amount]) && Not(ISBLANK(VALUE([Customer Target]))), 
  0 ,
  [Customer Target] / [DSAM Amount]
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago
The error says it all: you cannot compare bool values with text. Makes no sense... Here's how to use IF: IF( <logical_condition>, <case_for_True>, <case_for_False> ). You cannot do this True <> "". This comparison is not defined.