Forum Discussion
Line Chart Cumulative sum
Hello v-yulgu-msft ,
Sorry for clarity purposes the [Status Over Time] field is an updating list of dates based on the date the product status was changed. Therefore, the date the record for the product was created there would be no value(as record creation date is not recorded from the data we pull), the date the product is in production the date will change to that date and if the product is shipped, the [Status over Time] will be changed to the date it was shipped. The created count changes to 1 if the product is in production and 0 if the product is not. If a product has been shipped, it was in production at some point and should be included in the running total
I have this exact same challenge!
I used a quick measure to generate the running total, and it works for the full data set (cumulative sum of hours), but soon as i start selecting related visual elements from other charts, my line chart creates the dips as well 😞
[Time savings [h/year]] running total in Stage I Start date 2] = CALCULATE( SUM('Automation Project Portal'[Time savings [h/year]]]), FILTER( ALLSELECTED('Automation Project Portal'[Stage I Start date]), ISONORAFTER('Automation Project Portal'[Stage I Start date], MAX('Automation Project Portal'[Stage I Start date]), DESC) ) ) |
Intent is to similarly maintain the cumulatively rising line chart when table values are being filtered or selected.
running totals chart for entire dataset
|
running totals chart when data set is filtered/subset of data is selected
|
many thanks in advance!