Forum Discussion
Cumulative not working correctly
Resolver IVYou don't need to force the context transition, you have to break it!
First create a calculated column:
BreakContextTransitionTable =
VAR __YMTable = SUMMARIZE(ALL('Date'), 'Date'[MonthnYear])
VAR __YMTableEW = ADDCOLUMNS(__YMTable, "@EW", [EW])
RETURN
__YMTableEW
Then add this measure:
**bleep** EW =
VAR __filter = FILTER(BreakContextTransitionTable, BreakContextTransitionTable[MonthnYear] <= MAX('Date'[MonthnYear]))
RETURN
SUMX(__filter, BreakContextTransitionTable[@EW])
Giving this result:
Of course you can break the context transition by rewriting the EW measure (removing all Calculate())
Could you please attach pbix as well?
"First create a calculated column:" - You mean calculated table? Is there a way without creating calculated table?
"Of course you can break the context transition by rewriting the EW measure (removing all Calculate())" - I didnt understand this, would you be so kind to explain this a bit?
- JW_van_Holst
Sorry, calculated table.
Yes, theoretically it should be possible to do this with a measure that doesn’t use Calculate (that causes context transition). How ever due to the conditions in your measures on cumulative measures EW is non additive for all granularities and non additive for cumulative measures. It will be a great ask to solve it this way.
https://drive.google.com/file/d/1vblTL7cTzKQV1pBQRqG4uMH3pdXLUk9p/view?usp=sharing
I am sorry for asking again, but i always dont get this. So just want to be clear this time.
"How ever due to the conditions in your measures on cumulative measures EW is non additive for all granularities and non additive for cumulative measures"--Would you /someone be so kind to explain this a bit