topic Re: Issue creating measure dividing two columns in DAX Commands and Tips

Issue creating measure dividing two columns

Anonymous — Thu, 17 Feb 2022 05:44:03 GMT

I'm trying to divide two columns and then subtract it by 1

For example an expected output is
110,237.00 / 115,029.00 = 0.96

0.96 - 1 = -0.04

The measure I wrote is

Measure = DIVIDE( SUM([Column 1]) , SUM([Column 2]) , 0) - 1

When I add - 1 after divide the measure becomes very slow and gives the wrong output. All the values become -1.00
What am i doing wrong here?

Re: Issue creating measure dividing two columns

Anonymous — Thu, 17 Feb 2022 05:58:45 GMT

Your Measure is Right but make sure that your both column should the same format. Try to create a VARIABLE of divide and -1 from that VARIABLE. If it does not work then send sample data or a PBIX file.

Re: Issue creating measure dividing two columns

Anonymous — Thu, 17 Feb 2022 06:01:59 GMT

Both columns are decimal and I also tried making a variable of divide and subtracting by 1 but still same issue

Re: Issue creating measure dividing two columns

Anonymous — Thu, 24 Feb 2022 07:09:18 GMT

Hi Anonymous

Why not try calculated column ? Since you are dividing based on rows, calculated column would be more appropriate.

Original data (Decimal Number):

Then create a calculated column .

calculated Column = DIVIDE('Table'[Column1],'Table'[Column2])-1

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.