Forum Discussion

_Sarah_'s avatar
_Sarah_
Frequent Visitor
2 years ago

Iterate on multi selected slicer values

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

2 Replies

  • sjoerdvn's avatar
    sjoerdvn
    Solution Sage
    2 years ago

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

    • _Sarah_'s avatar
      _Sarah_
      Frequent Visitor
      2 years ago

      Hi,

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