I have this DAX query below that filters on Sales Reps but am having trouble turning it into a Paramater so my Paginated Report can filter on it using a drop down. Any help would be greatly appreciated!
DEFINE
VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('SalesByCust'[Name.1])),
'SalesByCust'[Name.1] IN
{"Sales Rep 1",
"Sales Rep 2",
"Sales Rep 3",
"Sales Rep 4",
"Sales Rep 5",
"Sales Rep 6",
"Sales Rep 7"}
)
EVALUATE
SUMMARIZECOLUMNS(
'SalesByCust'[CustomerName],
'SalesByCust'[Name.1],
__DS0FilterTable,
"v2023", 'SalesByCust'[2023],
"v1_Last_MTD_Sales", 'SalesByCust'[1_Last MTD Sales],
"v1_MTD_Sales", 'SalesByCust'[1_MTD Sales],
"SumProjected_Total", CALCULATE(SUM('SalesByCust'[Projected Total])),
"Var_to_Forecast", 'SalesByCust'[Var to Forecast],
"Sumv07", CALCULATE(SUM('ForecastSheet'[07]))
)
