topic Line Graph Resetting per Day in DAX Commands and Tips

Line Graph Resetting per Day

alex9999 — Mon, 25 Apr 2022 10:37:31 GMT

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.

Re: Line Graph Resetting per Day

johnt75 — Mon, 25 Apr 2022 14:50:58 GMT

Try

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

Re: Line Graph Resetting per Day

alex9999 — Wed, 27 Apr 2022 07:50:30 GMT

Hi johnt75 ,

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

Kind Regards,

Re: Line Graph Resetting per Day

johnt75 — Wed, 27 Apr 2022 08:58:35 GMT

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