YTD values from inicial of fiscal year up to the month selected

[DanielCarvalho]

I  have been trying to create a measure to get me a card with the total value of the fiscal year up to the month selected in the slicer but it is always getting me the value to the current day and not the selected month... Here is my current measure:

 = CALCULATE(COUNT(TICKET_DASHBOARD_GAVATAR[ACTIONDATE_FORMATTED]),DATESYTD(TICKET_DASHBOARD_GAVATAR[ACTIONDATE_FORMATTED], "30/9" ))

My fiscal year starts in october. How can I change this dax measure to give me up to the selected period instead of today? 

[DanielCarvalho · Accepted solution]

I have fixed it as it had to do with the relationships my calendar data had with my main table as a new column had to be created. 

In terms of the measure I ended up using, it was the following:

Closed_Tickets(YTD) = CALCULATE(SUM(TICKET_DASHBOARD_GAVATAR_HISTORY[Closed or Not]),DATESYTD('CALENDAR'[DATE], "30/9" ))

Kind Regards, Daniel

[Manokamna]

To modify your DAX measure to calculate the total value of the fiscal year up to the month selected in the slicer, you can replace the second argument of the DATESYTD function with a custom end date. Try this:

Total Value = CALCULATE(
COUNT(TICKET_DASHBOARD_GAVATAR[ACTIONDATE_FORMATTED]),
DATESYTD(TICKET_DASHBOARD_GAVATAR[ACTIONDATE_FORMATTED], "10/1"),
FILTER(
ALLSELECTED(TICKET_DASHBOARD_GAVATAR[ACTIONDATE_FORMATTED]),
TICKET_DASHBOARD_GAVATAR[ACTIONDATE_FORMATTED] <= MAX(TICKET_DASHBOARD_GAVATAR[ACTIONDATE_FORMATTED])
)
)

[DanielCarvalho]

The suggested measure is giving me the month to date value instead of year to date 

As you see i have both represented and the ytd and mtd and they both always the same regardless of whatever month I choose in my slicer