Forum Discussion

Ackbar-Learner's avatar
Ackbar-Learner
Icon for Resolver I rankResolver I
3 years ago
Solved

Measure taking too long

Hi I have a measure which is taking too long to calculate. All measures which precede this delaying measure are ok and do not take much time. See measure below:     Board10d7TaxAmountWithSignAct...
Idea
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

Please try this expression for your first measure instead.

Board10d7TaxAmountWithSignActualBudgetActualized =
VAR Result = [Board10cP&LAllTransactionAmountwithSignBudgetActualized]
VAR TaxApplicable =
    -1
        * MIN (
            [Board10d5TaxCalcPeriodActualBudgetActualized],
            [Board10d6TaxCalcCumulativeActualBudgetActualized]
        )
RETURN
    IF ( SELECTEDVALUE ( TabPLGLItem[GLItem] ) = "Tax", TaxApplicable, Result )

Pat

  • Ackbar-Learner's avatar
    Ackbar-Learner
    Icon for Resolver I rankResolver I
    3 years ago

    ppm1 , thanks for your reply. The code does give me the result but it does not improve the performance. I'll explain the measures leading to this measure in a post just below this and tag you again. Hopefully, you can find something which I could not see!

    • ppm1's avatar
      ppm1
      Icon for Solution Sage rankSolution Sage
      3 years ago

      Please see my recent video on how to isolate and test each of your measures to see which is the worst performer.  My guess it that it is one or both of the SUMX ones where you have a measure evaluated on each row (1b and 6b).

      https://www.youtube.com/watch?v=ScJVQoOWSqc

       

      Pat

       

      • Ackbar-Learner's avatar
        Ackbar-Learner
        Icon for Resolver I rankResolver I
        3 years ago

        @ppm this is a nice video. I watched the one after and tried to do the same to my model. I won't say it worked perfectly but it is much more improved now.

         

        As for the measure, which is taking a lot of time; it is the sheer amount of data, which is causing this issue. Once i optimized a bit more on the filter, it got much better.

         

        Thanks a lot.