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 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'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
    )

2 Replies

  • 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??