DAX Paginated Report: Optional Filtering

[sipati]

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: Table1[Column3] IN @Param1.
Dont apply Filter if: @Param1 contains -1

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).

Also, what should be the default value in Query Designer for @Param1?

[v-easonf-msft]

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