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! 😀
amitchandak
Super User
Super UserCosik ,
Please try like
Skumulowany =
CALCULATE (
SUM(Tracker[Dane_suma]),
FILTER(
ALLSELECTED(Tracker),
Tracker[RFS week]<=max(Tracker[RFS week])))
Refer this file, how to do week calculation using week rank: https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
CosikI have the same error as above.
Maybe I have something wrong im my measure.