I am struggling to get the cumulative total to work for this setup. I have gone through the videos and no matter what I do, I am not getting a cumulative total.

What am I missing? I am sure I am missing a fundamental concept but no matter what I read and try I keep getting the same result as TotalLosses for Cumulative Total rather than a cumulative total. After I figure this out, I need to actually do the cumulative total by Claim number so that for each claim number it adds up the losses to date for that claim.

Thanks in advance for any help that you can give me.

You have the right formula, just not the correct context of the calculation.

Instead of accident_date column in the table you require the dates column.

If you have a look at the formula and the FILTER part. You are removing context from the date table. But in your table there is no column from the actual date table. So this part of the formula is doing nothing in the current state.

Also instead of using all, consider using ALLSELECTED also.

Ahh - thank you! Just that simple comment cleared up a fundamental misunderstanding. Now it is working but with lots of empty rows - where there are dates in the date table with no match in the Losses table. This will be my next challenge to understand and perhaps the video you picked will help out there as well.

The reason why there are blank values again is for exactly the same reason. The context of the calculation is causing this due to the claim_no being from the fact table you have.

The concept of context sometimes takes a while to sink in but is absolutely crucial.

Here’s some good videos to review here, starting here

I will start with that video. I get the same result even when I remove the claim number. Hopefully, the video will help me sort that out. This is my current calculation based on your feedback

Cumulative Total = CALCULATE(
[TotalLosses],
FILTER(
ALLSELECTED('Dates'),
Dates[Date] <= max(Dates[Date])))

Thanks so much - the video’s are fantastic! The only thing I would like to get rid of is the repeating rows. There are only a few rows in the sample fact table but I am getting one row per each day in the date table for the year. This makes it hard to discern the real data values with all of the repeating rows. I would really like to only have one row per real data row and the cumulative total. The is the big thing that I can’t seem to figure out. Ideally, it would Iook like the below but with the cumulative total correct. I feel like once I understand the context more clearly, adding the claim_no to the mix won’t be that hard.