Pass a table to calculate with all applied external/internal filters but except on one column

[agarwal137]

Hi!
Can anyone please help me crack this -

Is there any way I can return a table with all the explicit and implicit filters applied, within calculate function, but remove filter, if any, on one column?

I tried with ALLSELECTED and it gives correct result by month until I do not pull any other dimension/column. I understand that All selected is keeping All External Filter context but then taking off any applied internal filter. I hope I was able to make the question & issue clear. Here is the formula and below screenshot where the DAX calculates correct at Month level but incorrect at the Region level. Any suggestion is much appreciated.

FY20SalesDelta =

var CurrentPeriodIndex = LOOKUPVALUE(LookUpCustomCalendar[Index],LookUpCustomCalendar[Reporting Period],MAX(FY20MonthlyData[Period]))

var PriorPeriodIndex = CurrentPeriodIndex -1

var PriorPeriod = LOOKUPVALUE(LookUpCustomCalendar[Reporting Period],LookUpCustomCalendar[Index],PriorPeriodIndex)

Return

[+FY20Sales] -

CALCULATE([+FY20Sales],

FILTER(

ALLSELECTED(FY20MonthlyData),

FY20MonthlyData[Period]=PriorPeriod)

)

[lbendlin]

Consider using KEEPFILTERS/REMOVEFILTERS as needed.

[agarwal137]

Hi Ibendlin. Thank you but unfortunately I could not figure it out with keepfilters/removefilters. If you could please create it for me, I'd very much appreciate your help.