Forum Discussion
Cumulative Line and Clustered Column Chart
Hi mtmcd
1. If the results You're looking for is the next picture...
try this measures...
Accumulative Actual = var actualdate = FIRSTNONBLANK(Process[Date];1) return CALCULATE([Total Quantity];ALL(Process[Date].[Day]);Process[Status] = "Actual";Process[Date] <= actualdate)
Accumulative Goal = var actualdate = FIRSTNONBLANK(Process[Date];1) return CALCULATE([Total Quantity];ALL(Process[Date].[Day]);Process[Status] = "Goal";Process[Date] <= actualdate)
Regards
BILASolution
Hi mtmcd
Here is the solution...
1. Sample Data: My table is called "Process"
2. Measures:
Total Quantity = SUM(Process[Quantity])
Total Actual = CALCULATE([Total Quantity];ALL(Process[Date].[Day]);Process[Status] = "Actual")
Total Goal = CALCULATE([Total Quantity];ALL(Process[Date].[Day]);Process[Status] = "Goal")
3. Final View
Regards
BILASolution
BILASolution, thank you for taking the time to propose a solution. However, it does not appear that the "Total Actual" and "Total Goal" lines in your chart are accurate. They are not plotting the running total of the values over time; they are all a steady amount.
As for my particular application, the Actual and Goal measures are coming up blank using your measures...
Wouldn't I need to implement a new column to calculate running total instead of a measure?
Hi mtmcd
1. If the results You're looking for is the next picture...
try this measures...
Accumulative Actual = var actualdate = FIRSTNONBLANK(Process[Date];1) return CALCULATE([Total Quantity];ALL(Process[Date].[Day]);Process[Status] = "Actual";Process[Date] <= actualdate)
Accumulative Goal = var actualdate = FIRSTNONBLANK(Process[Date];1) return CALCULATE([Total Quantity];ALL(Process[Date].[Day]);Process[Status] = "Goal";Process[Date] <= actualdate)
Regards
BILASolution