cancel
Showing results for
Did you mean:
Helper IV

## Flat Line in Cumulative Curve

Hey Guys - Any idea how to get rid of the BLACK FLAT LINE for Actuals? The Actual Curve should stop after TODAY's Date. The data extract is also shown below.

The Formula used for the Actual Curve is:

Cumulative Actual = CALCULATE (

SUM ('Contract Closeout Combined'[A]),

FILTER (

ALLSELECTED('Contract Closeout Combined'),

('Contract Closeout Combined'[Date] <= max('Contract Closeout Combined'[Date]))

))/sum('Total Progress (Forecast)'[Total Progress (Forecast)])

i tried replacing "('Contract Closeout Combined'[Date] <= max('Contract Closeout Combined'[Date]) with Today()"

but that did not work.

2 ACCEPTED SOLUTIONS
Super User II

What I would suggest you do is the following:

Create a measure for your A Value with the example below:

`A Total = IF(SUM('Table2'[A]) = 0,BLANK(),SUM('Table2'[A]))`

The above will always ensure that there is one place to change it, as well as then make it easier for the filter context later.

Then with the above measure you can now create your cumulative curve with the following measure.

```Cumulative Actual =
Var LNBD = LASTNONBLANK('Table2'[Date],[A Total])
RETURN
CALCULATE([A Total],FILTER(ALL('Table2'[Date]), 'Table2'[Date] <= LNBD))```

Proud to be a Super User!

Power BI Blog

Super User II
Hi there for your Year and Month values are those coming from the 'Progress Curve' table or the date table?

I think that might be the reason why it is not working as expected.

Proud to be a Super User!

Power BI Blog

24 REPLIES 24

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!