Sum of MoM change

[Anonymous]

Hi,

i have a time intelligence measure:

whereas

Using the the MoM measure in a table visualization i can see the ABS MoM change per Resource Name & Task Name, but what i actually need is the sum of the ABS MoM changes per month e.g. a table that would show me below result for 2023 March for a particular Resource Name of 3.06 (as indicated below) :

It seems pretty straightforward but i fail to get a viable solution.

Please help!

Thanks

Felix

[Anonymous]

I think in principle this measure should work (at least it does for a similar case that i've tested):

but apparently due to the time intelligence expression for SUMX it doesn't 😞

Maybe just a little tweak is needed here?!

[Anonymous]

Tried the MoM non-TimeIntelligence from here: https://amitchandak.medium.com/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e but can't make it work either (issue to even get the value for rank-1..)

[Anonymous]

I think I have narrowed down the issue. It is SUMX not working when a task disappeared from one month to another. The table/summation (when removing the task column) is working fine except for the cases where MoM change is -100% or 1 in absolute terms:

with

TEST_MD_%_per_task_MoM_change_ALLTASK = SUMX(SUMMARIZE(TimeTracking, TimeTracking[Task Name]), [TEST_MD_%_per_task_MoM_change])

I have to SUMMARIZE by [Task Name] otherwise i get 0 when removing the task name column but this i assume is at the same time leading to the issue that when the task only exists in a previous month it is not taken into consideration in the subsequent month.

Any sort of idea or help are still appreciated