# Power Pivot - Reverse Cumulative Measure

#### JamesAs

##### New Member
Hi,
Complete novice here within Power Pivot (But we've all got to start somewhere!)

Trying to create a visualization that shows a sort of burndown of tasks from left to right. I've utilized a measure which cumulates the total qty of tasks (some 380) of which 211 have been completed...but i'd like the inverse of this displayed. I've tried a method of reverse cumulation but just shows the tasks completed burning down not the total tasks leading down to remaining.

Help!

Cumulative Quantity All:=CALCULATE (
SUM ( 'MAIN TABLE'[CR =1] ),
FILTER (
ALL ( 'Dates'[Date] ),
'Dates'[Date] <= MAX ( 'Dates'[Date] )
)
)

Cumulative Quantity test:=CALCULATE (
SUM ( 'MAIN TABLE'[CR =1] ),
FILTER (
ALL ( 'Dates'[Date] ),
'Dates'[Date] >= MIN ( 'Dates'[Date] )
)
)

Main Table

 Task CR=1 Complete Date Complete T12345 1 1 14/07/2020​ T12346 1 (Blank) T12347 1 1 12/07/2020​ T12348 1 1 13/07/2020​ T12349 1 1 14/07/2020​ T12350 1 (Blank) T12351 1 1 15/05/2019​ T12352 1 1 16/05/2019​ T12353 1 (Blank) T12354 1 1 25/06/2020​ T12355 1 1 26/06/2020​ T12356 1 (Blank) T12357 1 1 24/01/2020​ T12358 1 (Blank) T12359 1 (Blank)

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Replies
0
Views
92
Replies
2
Views
95
Replies
0
Views
48
Replies
10
Views
245
Replies
2
Views
182