Tricjy Filtering issue with measure and filters

[Anonymous]

Hi Experts

Kindly ref to measure ACT 1 tables Fact Sales. 

I am trying to do a 1 to 1 comparison between current v prior forecast. The current forecast filters correct for all slicers on page. 

The prior forecast messure does not work correct for slicers Month, MTD YTD and FY and the Quarters.

Help been stuck on this for 2 days.

https://www.dropbox.com/s/0cjsoldsrlxuj6u/sampleData_.pbix?dl=0 

[amitchandak · Accepted solution]

@Anonymous , I looked at the file, Not able to get your prior year cal With use Act1. Why all and calendar 2

ACT1 = CALCULATE(Sum(FACT_SALES[Sales]),
        ALL('Calendar'),
            USERELATIONSHIP('Calendar'[Date],Calender_2[Date]))

Why not prior like

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))

[Anonymous]

Hi Amit,  kindly ignore the YTD and Quarter slicers

Can you get the Prior Forecast to filter data based on the month selection...please  this is causing me nightmares...stuck for 2 days..

I understand you are a clever super users.