topic Re: Help division error in DAX Commands and Tips

Help division error

pmadam — Mon, 14 Sep 2020 07:13:38 GMT

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 still get below error .

Kindly sugest

XY =

IF(ISBLANK([DSAM Amount]) && Not ISBLANK(VALUE([Customer Target])) <> "", 0 ,

(

([Customer Target] /

[DSAM Amount])))

Re: Help division error

Greg_Deckler — Mon, 14 Sep 2020 07:25:38 GMT

pmadam Use the DIVIDE function like this (get rid of the IF clause)

XY =DIVIDE([Customer Target],[DSAM Amount],0)

Third parameter is the one to return in case of divide by zero.

Re: Help division error

Anonymous — Mon, 14 Sep 2020 08:26:53 GMT

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.

Re: Help division error

pmadam — Mon, 14 Sep 2020 13:20:34 GMT

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.

Re: Help division error

Anonymous — Mon, 14 Sep 2020 13:46:03 GMT

pmadam

Why are you outputting numbers as text? This is not how you do stuff correctly. If you want to format a number in a visual, please use the formatting options in the ribbon, not the FORMAT function.

Re: Help division error

Pragati11 — Mon, 14 Sep 2020 13:52:58 GMT

Hi pmadam ,

Are bot of your columns numeric which you are trying to divide.

DIVIDE is function that works on non-text values. If you think logically, how can you divide a text value by a numeric value.

Try modifying data type of your text column used in DIVIDE function to Numeric.

Thanks,

Pragati

Re: Help division error

dedelman_clng — Mon, 14 Sep 2020 16:26:39 GMT

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

Re: Help division error

Greg_Deckler — Tue, 15 Sep 2020 00:36:58 GMT

pmadam Maybe:

XY = IF( ISBLANK([DSAM Amount]) && Not(ISBLANK(VALUE([Customer Target]))), 0 , [Customer Target] / [DSAM Amount] )

Re: Help division error

amitchandak — Tue, 15 Sep 2020 08:05:38 GMT

pmadam , Your measure should be divide( [Customer Target],[DSAM Amount],0)