Measure with a value filter calculated previously in a virtual table (generated with slicer filter)

Hi  JesusPenelas ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTCOLUMNS('DimCalendar',"MonthID",[Month_ID])
var _table=
FILTER('Fact_LFL_Store','Fact_LFL_Store'[Month_ID] in _select && [LFL_YN]<>1)
var _column=SELECTCOLUMNS(_table,"Date",[STORE_ID])
return
IF(
   NOT( MAX('FactSales'[STORE_ID])) in _column && MAX('FactSales'[Month_ID]) in _select,1,0)

Sum_Measure =
SUMX(ALLSELECTED('FactSales'),[SALES])

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Select 202208 202209 202210:

Select 202207 202208 202209:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly