List of value in power bi

[Otaku]

Hello, 

I am using Direct Query mode in Power BI.

In my underlying database, I have implemented partitions and clustering. I want to filter data in Power BI using a slicer based on a label (e.g., "Country Name" = Ireland) and send the corresponding SQL query to filter by id_country=32. Essentially, I want to replicate the functionality of SAP BO's 'List of Values'.

However, I would like to avoid overly complex solutions in Power Query as they might cause performance issues, particularly with dynamic M parameters.

How can I achieve this efficiently in Power BI?

Best regards

[VijayP]

@Otaku 

Create a Field Parameter using Country (Name it as Selection ) and you will get a slicer 

Create a Measure with SWITCH 

SWITCH(Selection, "Country1", calculated(measure,filter(table,country=country1) and so on) 

It should work efficiently!

[Otaku]

@VijayP any suggestion? thanks

[Otaku]

Hello @VijayP
Thank you for your response.
let explain more my need :

I want to be able to partition a BigQuery table by country name (string field) so that when end users filters to a specific country in BI application, they query a subset of the table in doing so.

Integer based partitioning works, but no one knows which country name is associated with which id_country.

Is there a common workaround for this?

Any thoughts/feedback/best practices would be greatly appreciated!