Add parameter to PBI published dataset for Paginated Report
I have this generated DAX query and need to add a Parameter in Query designer but it keeps giving me the Object not set reference: DAX Query: DEFINE VAR __DS0Core = SUMMARIZECOLUMNS( ROLLUPADDISSUBTOTAL( ROLLUPGROUP( 'Staff (PM)'[DCOO], 'Staff (PM)'[Cabinet Name], 'Staff (PM)'[Dept. Name], 'Staff (PM)'[Dept. Number], 'Staff (PM)'[COST_CENTER_NAME], 'Staff (PM)'[COST_CENTER], 'Contracts'[CONTRACT IDV], 'Contracts'[Contract Title], 'Contracts'[Vendor], 'Contracts'[Effective Date], 'Contracts'[Expiration Date], 'Contracts'[Amount Agreed], 'Contracts'[Remaining Contract Authority To Date], 'Contracts'[Projected No. of Months Remaining with Sufficient Authority], 'Contracts'[Projected Authority Exhausted], 'Contracts'[Projected No. of Months Requiring Additional Authority], 'Contracts'[Project Manager], 'Contracts'[Buyer/CA] ), "IsGrandTotalRowTotal" ), "SumContract_Term__Months_", CALCULATE(SUM('Contracts'[Contract Term (Months)])), "Monthly_Burn_Rate____Awarded_Amount", 'Contracts'[Monthly Burn Rate - Awarded Amount], "Amount_Invoiced", 'Contracts'[Amount Invoiced], "SumContract_Age__in_months_", CALCULATE(SUM('Contracts'[Contract Age (in months)])), "SumMonthly_Burn_Rate___Invoiced_Amount", CALCULATE(SUM('Contracts'[Monthly Burn Rate - Invoiced Amount])), "SumMonthly_Burn_Rate___Over_Run", CALCULATE(SUM('Contracts'[Monthly Burn Rate - Over Run])), "SumRemaining_Contract_Term__in_Months_", CALCULATE(SUM('Contracts'[Remaining Contract Term (in Months)])), "SumRemaining_Contract_Term__in_Days_", CALCULATE(SUM('Contracts'[Remaining Contract Term (in Days)])), "SumProjected_Contract_Overrun", CALCULATE(SUM('Contracts'[Projected Contract Overrun])), "SumProjected_Total_Contract_Term_Value", CALCULATE(SUM('Contracts'[Projected Total Contract Term Value])) ) EVALUATE __DS0Core ORDER BY [IsGrandTotalRowTotal] DESC, 'Staff (PM)'[DCOO], 'Staff (PM)'[Cabinet Name], 'Staff (PM)'[Dept. Name], 'Staff (PM)'[Dept. Number], 'Staff (PM)'[COST_CENTER_NAME], 'Staff (PM)'[COST_CENTER], 'Contracts'[CONTRACT IDV], 'Contracts'[Contract Title], 'Contracts'[Vendor], 'Contracts'[Effective Date], 'Contracts'[Expiration Date], 'Contracts'[Amount Agreed], 'Contracts'[Remaining Contract Authority To Date], 'Contracts'[Projected No. of Months Remaining with Sufficient Authority], 'Contracts'[Projected Authority Exhausted], 'Contracts'[Projected No. of Months Requiring Additional Authority], 'Contracts'[Project Manager], 'Contracts'[Buyer/CA] PARAMETER I want to add to the DAX Query: RSCustomDaxFilter(@DCOOParam,EqualToCondition,[Staff (PM)].[DCOO],String)
