Make filter to specific column

[dshah12]

I have Actuals Amount and Forecasts Amount in Power BI visualization , I want my date  filter to work on just Actuals Amount. How can I do that ?

Category	Actuals Amount	Forecasts Amount
abc	10000	20000
xyz	20000	40000

Please help me with the solution 

Thank you 

[ray_aramburo · Accepted solution]

Try using a measure for the Forecast instead:

Forecast_ExcludingDate = CALCULATE(SUM(TableName[ForecastAmountColumn]),REMOVEFILTERS('TableWithDate'[DateColumn]))

Just as a heads up, expect wonky results if you add date column to the existing visual.