Issue creating measure dividing two columns

[Anonymous]

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?

[Anonymous · Accepted solution]

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.

[Anonymous]

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.

[Anonymous]

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