performance analyzer
1 Topic
Performance Analyzer Query with 2 Parameters Run ok in DAX Studio, No Rows Found in Report Builder
Hi Guys, The below Query runs perfectly in 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]Solved2.7KViews0likes6Comments