Forum Discussion

Cosik's avatar
Cosik
Icon for Helper I rankHelper I
6 years ago
Solved

Create 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...
Need Help
  • lkalawski's avatar
    lkalawski
    6 years ago

    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's avatar
Cosik
Icon for Helper I rankHelper I
6 years ago

It is closer,

It gives me sum of all selected weeks.

 

lkalawski's avatar
lkalawski
Icon for Resident Rockstar rankResident Rockstar
6 years ago

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's avatar
    Cosik
    Icon for Helper I rankHelper I
    6 years ago

    Thx guys, you help me a lot.