Forum Discussion
DAX Paginated Report: Optional Filtering
Hi, Assume I have a multi value parameter (contains integers): "Param1" And I have a query: "EVALUATE SUMMARIZEROWS(Table1[Column1], Table1[Column2], Table1[Column3])" Filter to be applied: Ta...
Hi, sipati
I think you are referring to SUMMARIZE or SUMMARIZECOLUMNS.
Maybe you can try fuction 'SELECTCOLUMN '.
When using DAX for SSRS, you should use a general outline for your DAX queries.
Please check if these related threads could help.
https://community.powerbi.com/t5/Report-Server/Paginated-Reports-quot-All-quot-parameter/m-p/695067
https://adatis.co.uk/ssrs-and-dax/
https://docs.microsoft.com/lv-lv/power-bi/paginated-reports/paginated-reports-parameters
Best Regards,
Community Support Team _ Eason