@_mk7 Your code is slow because of the measures that you are using in the Filters pane, you have used the code shared earlier in a row context inside an iterator, which is making it difficult for the DAX engines, since this requires dedicated time, it is not possible to resolve this.
DEFINE
VAR __DS0FilterTable =
FILTER (
KEEPFILTERS ( VALUES ( '% Dif Slider'[% Dif] ) ),
'% Dif Slider'[% Dif] = 1
)
VAR __DS0FilterTable2 =
FILTER (
KEEPFILTERS ( VALUES ( 'Unit Dif Slider'[Unit Dif] ) ),
'Unit Dif Slider'[Unit Dif] = 1000
)
VAR __DS0FilterTable3 =
FILTER (
KEEPFILTERS ( VALUES ( 'DimItem'[ITEM] ) ),
NOT ( ISBLANK ( 'DimItem'[ITEM] ) )
)
VAR __DS0FilterTable4 =
FILTER (
KEEPFILTERS ( VALUES ( 'DimStore'[STORE] ) ),
NOT ( ISBLANK ( 'DimStore'[STORE] ) )
)
EVALUATE
FILTER (
KEEPFILTERS (
SUMMARIZECOLUMNS (
'DimItem'[ITEM],
'DimWeek'[ADJ_AD_WEEK_START_DT],
__DS0FilterTable,
__DS0FilterTable2,
__DS0FilterTable3,
__DS0FilterTable4,
"Min_Total_Sales__ITEM_", 'Key Measures'[Min Total Sales (ITEM)],
"Pct_Dev_from_Min__Outlier_Perc_Filter_", IGNORE ( 'Key Measures'[Pct Dev from Min (Outlier Perc Filter)] ),
"Forecast__Outlier_Units_Filter_", IGNORE ( 'Key Measures'[Forecast (Outlier Units Filter)] )
)
),
AND (
NOT ( ISBLANK ( [Pct_Dev_from_Min__Outlier_Perc_Filter_] ) ),
NOT ( ISBLANK ( [Forecast__Outlier_Units_Filter_] ) )
)
)
Time taken in preparing the filter context from the slicer:
