Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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])

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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
Not applicable

AllToKnow00_0-1647879126365.png

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.

AllToKnow00_1-1647879478099.png

 

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!

 

 

Hi @Anonymous ,  

 

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

1.png

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors