Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Accumulative Value in Line Chart

Hello there,

 

First of all, excuse me and my low skills on DAX.

I have this "Earnings" column, and I need a Line chart where it shows an Accumulative version during time with the legend of the shop_id.

This table is on DirectQuery mode, but I think this Accumulative measure can be done in the Desktop page.

 

FYI: The chart will be showing real-time data and only for the current day (I don't know if this info is helpful and important for the measure, sorry).

SHOP_IDEARNINGSTIME
1$45.6016:50
2$980,654.8811:20
3$324.0113:30
4$109:10
5$54.7822:20

 

Any help or advice would be kindly appreciated.

 

Thank you!

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Ideal is datetime column and cumulative like

     

    sumx(filter(allselected(Table), Table[Datetime] <= Max(Table[Datetime])), Table[Earning])

     

    or

    sumx(filter(allselected(Table), Table[Datetime] <= Max(Table[Datetime]) && Table[ID] = max(Table[ID]) ) , Table[Earning])

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Ideal is datetime column and cumulative like

     

    sumx(filter(allselected(Table), Table[Datetime] <= Max(Table[Datetime])), Table[Earning])

     

    or

    sumx(filter(allselected(Table), Table[Datetime] <= Max(Table[Datetime]) && Table[ID] = max(Table[ID]) ) , Table[Earning])

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      When using the second design, the one with IDs, I get the chart above. And when I use the first one, I get the chart below with the value accumulating in all the shops at the same time.

       

      I think I must add that each shop_id will appear more than once in the table, because you can buy something in one shop several times on several days.

       

      What I'm trying to draw is one continuous accumulative line for each shop during that time period.

       

      Sorry for all this bothering, and thank you for your time and patience!

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,  

         

        I agree with amitchandak 's second code. I have a test by amitchandak 's code, and it will work in my sample. 

        Could you share more details about your data model or share a sample file created by import mode with us? This will make it easier for us to find the solution.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.