Forum Discussion
Cosik
Helper I
Helper ICreate Cumulative line from measure
Hi, I'm strugling to create cumulative line. I know how to do in theory but I'm stuck on one of the steps. I can't use measure in calculation and I don't know how to convert this. This is wha...
Maybe this? :
Skumulowany = SUMX ( FILTER ( ALLSELECTED ( Tracker ), Tracker[RFS week] <= max(Tracker[RFS week]) ), [Dane_suma] )
_______________
If I helped, please accept the solution and give kudos! 😀
CosikHelper I
Helper II have error.
The "Dane_suma" can't be found in "Tracker" table or you can't use it here.
lkalawski
Resident Rockstar
Resident RockstarSure, because it is a measure and should be like this:
Skumulowany =
SUMX (
FILTER ( ALLSELECTED ( Tracker ), Tracker[RFS week] <= Tracker[RFS week] ),
[Dane_suma]
)
_______________
If I helped, please accept the solution and give kudos! 😀
- Cosik
It is closer,
It gives me sum of all selected weeks.