Forum Discussion
Solved
Measure Total value: change the default behaviour
Hi everyone, i have a problem with a total value of a measure. "Δ su Budget" measure value is correct in row context. Δ su Budget = divide(sum(FACT_PL_FATTURATO[IMPNETTO])-[ImpNettoAp],[ImpNett...
PSampras ,
You may be able to get it using a similar fashion:
#Delta = VAR _Actual = SUM('Table'[Actual]) // replace this with the sum of your actuals VAR _Budget = SUM('Table'[Budget]) // replace this with the sum of your budget VAR _Delta = SUM('Table'[Delta]) // replace this with your current measure --> divide(sum(FACT_PL_FATTURATO[IMPNETTO])-[ImpNettoAp],[ImpNettoAp]) RETURN // I selected classification but this value should be on your table somewhere. You can also interchange and use ISINSCOPE instead of HASONEFILTER IF( HASONEFILTER('Table'[Classification]), _Delta, DIVIDE(_Actual - _Budget, _Budget))Here's an example output:
PSampras ,
You may be able to get it using a similar fashion:
#Delta =
VAR _Actual = SUM('Table'[Actual]) // replace this with the sum of your actuals
VAR _Budget = SUM('Table'[Budget]) // replace this with the sum of your budget
VAR _Delta = SUM('Table'[Delta]) // replace this with your current measure --> divide(sum(FACT_PL_FATTURATO[IMPNETTO])-[ImpNettoAp],[ImpNettoAp])
RETURN
// I selected classification but this value should be on your table somewhere. You can also interchange and use ISINSCOPE instead of HASONEFILTER
IF( HASONEFILTER('Table'[Classification]), _Delta, DIVIDE(_Actual - _Budget, _Budget))
Here's an example output:
Thank you very much hnguy71 , it works!
#Delta =
VAR _Actual = SUM(vods_facAgr_ITA[ImpNetto]) // replace this with the sum of your actuals
VAR _Budget = SUM(vods_facAgr_ITA[ColBudgetRigaClassificatore]) // replace this with the sum of your budget
VAR _Delta = divide(sum(vods_facAgr_ITA[ImpNetto])-sum(vods_facAgr_ITA[ColBudgetRigaClassificatore]),sum(vods_facAgr_ITA[ColBudgetRigaClassificatore])) // replace this with your current measure --> divide(sum(FACT_PL_FATTURATO[IMPNETTO])-[ImpNettoAp],[ImpNettoAp])
RETURN
// I selected classification but this value should be on your table somewhere. You can also interchange and use ISINSCOPE instead of HASONEFILTER
IF( HASONEFILTER(vods_facAgr_ITA[Classificatore]), if(isblank(_Delta),1,_Delta), DIVIDE(_Actual - _Budget, _Budget))
hehee, i'm glad it worked out! Enjoy!