Calculating Running Total using DAX Measures

[bourne2000]

Hi 

I have four tables which is connected as below

I have calculated below measures

Total Hours = CALCULATE(SUM('project__employee_timesheet'[Total Hours]),'aloro_live project__costcode_budget'[project_token] = "76212727")

JTD Qty Complete = CALCULATE(SUM('aloro_live project__costcode_quantity'[quantity]),'aloro_live project__costcode_quantity'[project token] = "76212727" )

JTD Unit Hours = IFERROR([Total Hours]/[JTD Qty Complete],0) * 100

All the above three measures are working correct. I would like calculate running total for JTD Unit Hours and I used below two measures but results are not correct

JT Unit Hours RT = SUMX(FILTER(ALLSELECTED('Date'[Date]), 'Date'[Date]<=MAX('Date'[Date])), [JTD Unit Hours])

If I use the above formula, I am getting below results. I visualize using weekend date

I used another below dax measures to calculate Running total again, the results are not correct

Unit Hours RT = CALCULATE([JTD Unit Hours], DATESYTD('Date'[Date]))

[bourne2000]

@amitchandak  Thanks. I marked the date table as date table. Still running total is not working.

[amitchandak]

@bourne2000 , Make sure date table is marked as date table. Column from Date table is used in visual for a week, month etc

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.