Forum Discussion
Cumulative line chart in combo chart
Hi there I currently have a combo chart that looks like this: The chart is based on a measure "Hours Saved" and shows values for each transaction date. I ...
Using your solution seems to just give the same result without accumulation.
My "Hours Saved" measure as calculated like this:
Hours Saved = SUMX(QueueDB; RELATED(queuesROI[timeValueMin]))/60
I tried to calculate it this way:
Cumm = CALCULATE([Hours Saved];FILTER(QueueDB;QueueDB[transactionEND] <=MAX(QueueDB[transactionEND])))
Hi Anonymous ,
Refer the formula below and see if it helps.
Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date]))
Measure 2 = CALCULATE([Measure],FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])))Here's the result about my sample data.
If this not help, please share some sample data if you don't have any Confidential Information.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
How do I upload a data sample here for you to see?