idea
1 Topic
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: Board10d7TaxAmountWithSignActualBudgetActualized = VAR Result = [Board10cP&LAllTransactionAmountwithSignBudgetActualized] VAR TaxApplicable = -1*if([Board10d6TaxCalcCumulativeActualBudgetActualized]>[Board10d5TaxCalcPeriodActualBudgetActualized],[Board10d5TaxCalcPeriodActualBudgetActualized],[Board10d6TaxCalcCumulativeActualBudgetActualized]) RETURN calculate(if(if(HASONEVALUE(TabPLGLItem[GLItem]),values(TabPLGLItem[GLItem]))="Tax",TaxApplicable,Result)) Just after this measure, i made another measure to summarize this one. Board10d8PLTaxAmountWithSignActualBudgetActualized = SUMX ( SUMMARIZE (TabPLGLItem,[GLItem]), CALCULATE ( VAR result = [Board10d7TaxAmountWithSignActualBudgetActualized] RETURN result ) ) Any idea to make this more efficient! ThanksSolved6.1KViews0likes9Comments