Fiscal YTD calculation using DATESYTD get 50% result wrong.

[asfdwd]

BillUnitsMonthly = CALCULATE(SUM(MonthlyReport[Subscript]),

ALL('Calendar'[FiscalYear]),

'Calendar'[FiscalYearNo]<=MAX('Calendar'[FiscalYearNo])

)

BillUnits FYTD = CALCULATE([BillUnitsMonthly],DATESYTD('Calendar'[Date],"31/3"))

The .pbix file can be download from the link.

https://1drv.ms/u/s!ArFNhSS94KaIgp8s2FoB6XK-ws-hrw

[Ahmedx · Accepted solution]

pls try this

BillUnitsMonthly = CALCULATE(SUM(MonthlyReport[Subscript]),
REMOVEFILTERS(),VALUES('Calendar'[FiscalMonth]),
'Calendar'[FiscalYearNo]<=MAX('Calendar'[FiscalYearNo])
)

[asfdwd]

Not understand the logic behind it. But this code works perfectly for my report!

Thank you.