Line Graph Resetting per Day

[alex9999]

Hi All,

I have looked into this and can't find a suitable solution for my problem.

I have created a line graph on my project which shows "Total Tonnage". Once we recorded the first day for the data, the tonnage was fine, but going into the second day I realised it only recorded what was on that day instead of keeping a consistent line across with the tonnage. Can somebody help me?

Here is a screenshot of the issue.

[johnt75]

Try

Total tonnage =
var maxDate = MAX('Date'[Date])
return CALCULATE( SUM('Table'[Tonnage]), REMOVEFILTERS('Date'), 'Date'[Date] <= maxDate )

[alex9999]

Hi @johnt75 ,

Thanks for the reply. Unfortunately the DAX measure has the same output as before.

Kind Regards,

[johnt75]

Are you sure you are removing filters from the entire Date table rather than a specific column ? When working with dates on visuals it is common for sort by columns to be added behind the scenes, and these would therefore be added to the filter context.

You can see exactly what is being included by using Performance Analyzer to get a copy of the generated code and examine it in DAX Studio