DAX Help

[Naveen29]

I have matrix visual which is having the combination of the FY, YTD ,MTD measures . The FY sales data should be whole year data regardless of the what you select in the slicer values (Year, Month)

FY Sales = CALCULATE (Sales, DATESYTD(ftcalendar[Date],"12/31")) - This should be constant value regardless of the Year, Month selection. This is not giving exact results. What is the best calucation for FY and previous financail year calucation measures.

[Anonymous]

Not sure if this is what you're looking for:

ALLEXCEPT – DAX Guide

[sirlanceohlott]

You could apply an ALL filter to the measures so they are not affected by the slicers you've mentioned. 

https://dax.guide/all/

[Naveen29]

I tried this option however it is not working

[Naveen29 · Accepted solution]

I found the solution. FY Sales = TOTALYTD=(SALES, ENDOFYEAR(CALENDARDATE))