Forum Discussion

MP-iCONN's avatar
MP-iCONN
Icon for Resolver I rankResolver I
3 years ago

Turning a filter into a parameter for a Paginated Report

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

No RepliesBe the first to reply