idea

2 Topics

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! Thanks
Solved
Ackbar-Learner
3 years ago Place DAX Commands and Tips
6.1KViews
0likes
9Comments
Creating a measure to Count as 1 when everyday user Check In Twice in Applicaiton
Hello! I am trying to create a report for Temperature Check in daily for my organization use. A staff need to check in the application twice a day, which is morning and evening. Can we create a measure that count as 1 when a user check in twice a day ? Example: Check In Morning Check In Evening Count as 1 Yes Yes 1 Yes No 0
pravind96
5 years ago Place Custom Visuals Development Discussion
1KViews
0likes
1Comment