Forum Discussion

mmowrey's avatar
mmowrey
Icon for Helper I rankHelper I
4 years ago

Running total stops calulating.

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 Project...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    mmowrey
    Icon for Helper I rankHelper I
    4 years ago

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