Forum Discussion

anshusaketsingh's avatar
anshusaketsingh
Frequent Visitor
2 years ago
Solved

Query To Pass Multiple Values From a Parameter in Paginated Report Using RSCustomDaxFilter

I am trying to create a Paginated report with Category as filter. Its working fine with DAX file but they can only accept 1 value at a time. I switched to RSCustomDaxFilter but somehow getting the b...
Need Help
  • anshusaketsingh's avatar
    anshusaketsingh
    2 years ago

    So, apparently it is some weird bug in PowerBI Report Builder.

    Rewriting the same query without space for RSCustomDaxFilter like below solved the problem.

     

    DEFINE
    VAR FilterTable =
    RSCustomDaxFilter(@Category,EqualToCondition,[Orders].[Category],String)

    EVALUATE
    SUMMARIZECOLUMNS (
    'Orders'[Category],
    'Orders'[Sub-Category],
    FilterTable,
    "SumSales", CALCULATE ( SUM ( 'Orders'[Sales] ) )
    )
    ORDER BY
    "SumSales" DESC,
    'Orders'[Category],
    'Orders'[Sub-Category]

anshusaketsingh's avatar
anshusaketsingh
Frequent Visitor
2 years ago

So, apparently it is some weird bug in PowerBI Report Builder.

Rewriting the same query without space for RSCustomDaxFilter like below solved the problem.

 

DEFINE
VAR FilterTable =
RSCustomDaxFilter(@Category,EqualToCondition,[Orders].[Category],String)

EVALUATE
SUMMARIZECOLUMNS (
'Orders'[Category],
'Orders'[Sub-Category],
FilterTable,
"SumSales", CALCULATE ( SUM ( 'Orders'[Sales] ) )
)
ORDER BY
"SumSales" DESC,
'Orders'[Category],
'Orders'[Sub-Category]