Forum Discussion
Helper IIParameters in Report Builder (DAX query copied from Performance Analyzer)
Hi d_gospel,
The below Query runs on DAX Studio, But returns no rows found in Report Builder.
I am passing the report Parameters @Location and @Date as the query parameters
What am I Possibly not doing?
// DAX Query
DEFINE
VAR __DS0FilterTable =
TREATAS({@Location}, 'CSLOCATION'[Location])
VAR __DS0FilterTable2 =
FILTER(
KEEPFILTERS(VALUES('Date Dim'[Date])), 'Date Dim'[YYYY/MM]= @Date)
)
VAR __DS0Core =
SUMMARIZECOLUMNS(
'CSPDETAILS'[Criteria],
__DS0FilterTable,
__DS0FilterTable2,
"Score", 'RM'[Score],
"Result", IGNORE('RM'[Result]),
"Color", IGNORE('RM'[Color])
)
VAR __DS0PrimaryWindowed =
TOPN(1001, __DS0Core, [Score], 0, 'CSPDETAILS'[Criteria], 1)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
[Score] DESC, 'CSPDETAILS'[Criteria]
Super User
ugoriuko wrote:
The below Query runs on DAX Studio, But returns no rows found in Report Builder.
I am passing the report Parameters @Location and @Date as the query parameters
What am I Possibly not doing?
I can't see how it could run in DAX Studio since your expression for __DS0FilterTable2 is not valid. It includes an extra unmatched closing parathesis and you can't filter using the [YYYY/MM] column when the table you are filtering only contains the values from the [Date] column.
If you can run an All Queries trace against your data source you should be able to capture the full query including the parameter XML block when you run from Report Builder, then you should be able to see what values Report Builder is passing through. Maybe there is some extra formatting happening somewhere and the parameters values are being passed differently to what you expected.