I have a table of hourly production table and a line chart.
I would like to draw a line chart to show the cumulative total of 'Inc' & 'Act' of the one day with the selection of dates in my slicer.
I wrote my measure, but it won't reset after new day.
From the image below, on 11/8/2020 8AM the Incremental value should show 85 instead of (85+93 = 178) which is the cumulative total from previous day (10/8/2020 8AM). When it goes to new day, the cumulative should restart.