DATESYTD Not Working in Calculated Column Using Fiscal Date

Hi,

I'm trying to create a calculated column for YTD value using fiscal date, but it doesn't work. I've searched on many solved similar problems, but it's still not working till now. Here is the formula I use:

CALCULATE(SUM(Compiled[Client]), DATESYTD('Date Fiscal'[Date], "04/31")

Here is the table relation (month in Compiled table is a full-set date):

table relation

And this is the result I got:

Result

Column "Sum of Client" is the data that I want to calculate, Column "Sum of Client YTD Col" is a calculated table that doesn't give my expected result, Column "Client YTD" is a measure and gives me the result I expected.

The reason I need to make YTD in calculated column instead of measure is becauese I want to make a calculated column of category based on the value of YTD, and then use that category colum as a slicer.

Can anyone help me with this please? Thank you..