Forum Discussion
Naveen29
4 years agoHelper II
DAX Help
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.
I found the solution. FY Sales = TOTALYTD=(SALES, ENDOFYEAR(CALENDARDATE))
4 Replies
- sirlanceohlottAdvocate III
You could apply an ALL filter to the measures so they are not affected by the slicers you've mentioned.
- AnonymousNot applicable