Create Cumulative line from measure

[Cosik]

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 what I have:

I have create 3 measure:

Dane_1 - CALCULATE (COUNTROWS (Tracker),FILTER (Tracker,Tracker[PIF Status]="COMPLETED"&& Tracker[Type]="other"))

Dane_2 - CALCULATE (COUNTROWS (Tracker),FILTER (Tracker,Tracker[PIF Status]="IN PROGRESS"&& Tracker[Type]="other"&& Tracker[Group from MDS]<>"5"&&Tracker[Group from MDS]<>"4"))

Dane_suma - Dane_1 + Dane_2

The 3rd I want to use to create cumulative line.

I try to use such code but i can't use measue inside calculation 😐

Skumulowany =

CALCULATE (

SUM(Tracker[Dane_suma]),

FILTER(

ALLSELECTED(Tracker),

Tracker[RFS week]<=Tracker[RFS week]))

Below you can see printscreen, the one on the top is final result, the rest are just for testing. I also try to create new column with   Dane_1 calculation but it gives me strange numbers (on the bottom left table).

I will be very gratefull for any kind of tips which will help me deal with it.

[amitchandak]

@Cosik ,

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

[Cosik]

I have the same error as above.

Maybe I have something wrong im my measure.

[lkalawski]

Hi Cosik,

Try SUMX function:

Skumulowany =
SUMX (
    FILTER ( ALLSELECTED ( Tracker ), Tracker[RFS week] <= Tracker[RFS week] ),
    SUM ( Tracker[Dane_suma] )
)

_______________
If I helped, please accept the solution and give kudos! 😀

[Cosik]

I have error.

The "Dane_suma" can't be found in "Tracker" table or you can't use it here.

[lkalawski]

Sure, 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.

[lkalawski · Accepted solution]

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! 😀

[Cosik]

Thx guys, you help me a lot.