Turning a filter into a parameter for a Paginated Report

MP-iCONN — Mon, 24 Jul 2023 15:31:46 GMT

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]))
        )

topic Turning a filter into a parameter for a Paginated Report in Report Server

Turning a filter into a parameter for a Paginated Report