How to handle Paginated reports Multi-Valued Parameters in DAX Queries

[Baskar]

Hi Team, 

     Need help to setup multi-value parameter in DAX Queries.

Source : Power BI Dataset

Creating dataset with DAX Queries. Have to pass user selected paramter into DAX dynamically. 

How to use DAX "IN" in this scenario.

[v-shex-msft]

HI @Baskar,

Perhaps you can take a look at the following blogs of 'power bi report build and custom dax filter' and 'String split' if they suitable for your requirement:

Power BI Report Builder And RSCustomDaxFilter 

Power BI Paginated reports: using String_Split to improve multi-value parameters 

Regards,

Xiaoxin Sheng

[amitchandak]

@Baskar ,

Not very clear

calculate(countrows(Table), filter(Table, Table[Col] in values(Param[param])))

or

calculate(countrows(Table), filter(Table, Table[Col] in allselected(Param[param])))