Month Slicer returning MTD values on YTD formula

DAX DAX Calculations
1

Hi :slight_smile: ,
I have few tables and charts based on YTD formulas in my model.
I also have dropdown slicers for months to be selected.

Now the issue is when i select a particular month, say March, in the slicer, all the figures in tables and charts show values for MTD March 2019 instead of YTD March 2019.

Any idea on what could be the possible reason for this.

2

Any chance you can upload some sample data that shows the problem you are facing? Sounds like a filter context issue, but easier to diagnose when I am able to see it.

-Nick

Enterprise%20DNA%20Expert%20-%20Small

3

Thanks,
Solved it.

Removed the filter function from the calculate formula and it worked. :slight_smile: