DAX Paginated Report: Optional Filtering

Question

Hi,&nbsp;Assume I have a multi value parameter (contains integers): "Param1"And I have a query: "EVALUATE SUMMARIZEROWS(Table1[Column1], Table1[Column2], Table1[Column3])"&nbsp;Filter to be applied: Table1[Column3] IN&nbsp;@Param1.Dont apply Filter if:&nbsp;@Param1 contains -1&nbsp;Also, I dont want to SUMMARIZEROWS. How can I EVALUATE without SUMMARIZEROWS? I don't want to fetch all columns from Table1, just specific columns (excluding Column3).&nbsp;Also, what should be the default value in Query Designer for&nbsp;@Param1?

v-easonf-msft · Answer

Hi,&nbsp;&nbsp;sipati&nbsp;
I think you are referring to SUMMARIZE or SUMMARIZECOLUMNS.
Maybe you can try fuction&nbsp; 'SELECTCOLUMN&nbsp;'.
&nbsp;
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&nbsp;
https://adatis.co.uk/ssrs-and-dax/&nbsp;
https://docs.microsoft.com/lv-lv/power-bi/paginated-reports/paginated-reports-parameters&nbsp;
&nbsp;
&nbsp;
Best Regards,Community Support Team _ Eason
&nbsp;

Forum Discussion

DAX Paginated Report: Optional Filtering

1 Reply

Related content

Paginated report - optional parameter

Paginated Report

Saving filter options

Filters on Paginated Report

Paginated report