Running total stops calulating.

[mmowrey]

I have a running total that will only work for a range of 7 days.. if i add any more days it just keeps repeating the last value

Monthly Running Total Goal (RBC) =

CALCULATE(

[Red Cell Projected],

FILTER(

ALLSELECTED(BloodDrive[DriveDate]),

BloodDrive[DriveDate]<= MAX(BloodDrive[DriveDate])

)

)

[tamerj1]

@mmowrey 

Can you please share the complete table screenshot? What source tables are are involved in this table visual?

[amitchandak]

@mmowrey , do have data for those additional days ?

Assuming - Red Cell Projected is measure

This seems fine. or try like  

CALCULATE(
[Red Cell Projected],
FILTER(
ALL(BloodDrive[DriveDate]),
BloodDrive[DriveDate]<= MAX(BloodDrive[DriveDate])
)
)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[mmowrey]

There is data for those other days.. and if i just run for those days it calculates.. It just stops after 7 days