Forum Discussion
Cumulative not working correctly
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?
Resolver IVSorry, 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