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]
)
pmadam's avatar
pmadam
Icon for Helper II rankHelper II
6 years ago

Hi Greg_Deckler ,

 

I get error. These measures are in text because when i added comma seperator, the measures were converted to type int to text.

 

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
6 years ago

pmadam you have the wrong syntax for DIVIDE:

 

Greg_Deckler 's code:  XY =DIVIDE( [Customer Target], [DSAM Amount], 0 )

 

Your code: XY =DIVIDE( [Customer Target] / [DSAM Amount] ,0 ). 

 

Even if you didn't throw an error with one of your "numbers" being empty, you are dividing by 0.

 

Hope this helps

David