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)
