topic Re: Iterate on multi selected slicer values in DAX Commands and Tips

Iterate on multi selected slicer values

_Sarah_ — Wed, 20 Mar 2024 16:03:28 GMT

Hi All,

I have a multi-select slicer (named Clients) that I want to use for filtering the table rows acting on the Customers column.

For example, looking at the image, the selected rows should be the ones pointed.

I think I need to combine DAX functions ALLSELECTED and CONTAINSSTRING but I don't know how.

Thanks for your support.

Sarah

Re: Iterate on multi selected slicer values

sjoerdvn — Wed, 20 Mar 2024 16:12:56 GMT

You need to share the relevant tables and relationships in your model. If you have a dimension table with that "Clients" Column that has a relationship with the table that has the "Customers" column, you don't need any dax...

Re: Iterate on multi selected slicer values

_Sarah_ — Wed, 20 Mar 2024 16:16:15 GMT

Hi,

no relation between "Clients" and "Customers", they came from distinct sources.