Forum Discussion

Euro0681's avatar
Euro0681
Helper II
3 years ago
Solved

Adding 1 to Divide()

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 a...
  • tamerj1's avatar
    tamerj1
    3 years ago

    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
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

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's avatar
Euro0681
Helper II
3 years ago

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