Forum Discussion

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

Line Graph Resetting per Day

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

Try

Total tonnage =
var maxDate = MAX('Date'[Date])
return CALCULATE( SUM('Table'[Tonnage]), REMOVEFILTERS('Date'), 'Date'[Date] <= maxDate )
alex9999's avatar
alex9999
Icon for Helper I rankHelper I
4 years ago

Hi johnt75 ,

 

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

 

Kind Regards,

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    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