topic Re: Running total stops calulating. in DAX Commands and Tips

Running total stops calulating.

mmowrey — Wed, 27 Apr 2022 16:17:12 GMT

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])

)

amitchandak — Wed, 27 Apr 2022 16:21:00 GMT

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 — Wed, 27 Apr 2022 16:28:03 GMT

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

tamerj1 — Wed, 27 Apr 2022 17:26:20 GMT

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