Adding 1 to Divide()

[Euro0681]

maybe someone can clear up

I have a measure that simply divides 2 amount

Meausure = Divide( 'Table'[Amount1] - 'Table'[Amount2] , ABS( SUM( 'Table'[Amount2] ) ) ) 

using this measure works and super fast in performance, but.....

Measure 2 = Divide( 'Table'[Amount1] - 'Table'[Amount2] , ABS( SUM( 'Table'[Amount2] ) ) ) + 1

breaks visual and says I have exceeeded resources why?

[tamerj1 · Accepted solution]

Hi @Euro0681 

+1 will force the engine to perform the calculation over all the rows of the visual. You may try

Measure3 =
IF (
NOT ISBLANK ( 'Table' ),
DIVIDE (
SUM ( 'Table'[Amount1] ) - SUM ( 'Table'[Amount2] ),
ABS ( SUM ( 'Table'[Amount2] ) )
) + 1
)

[Euro0681]

Thanks! This works how does this measure work as opposed to the one I used??