Ignore Selection in expression, but not in for table

[Apfelbaum]

Hi, 

so I have the following question. I want to ignore the selection of a certain dimension in one expression, but still want that the table to be filtered for that dimension. 

Following example

ID	Project	Project Lead
1	Dog	Josh; Marc
2	Cat	Sophie; Julian

So when I filter for Josh, the table looks like that 

ID	Project	Project Lead
1	Dog	Josh

But I want it to look like that: 

ID	Project	Project Lead
1	Dog	Josh; Marc

ID and Project are dimensions. Project Lead is a expression with Concat(Distinct ProjectLead, '; ')

When I use Set Expression and filter for Josh in ProjectLead, the whole table will not filter anymore. I used Concat({< ProjectLead = >} (Distinct ProjectLead, '; ') . This is the result: 

ID	Project	Project Lead
1	Dog	Josh; Marc
2	Cat	Sophie; Julia

Anyone got an idea, how I can achieve this? 

Looking forward for your input! 

[rubenmarin · Accepted solution]

Hi, you can try with: Concat({<Project=P(Project), [Project Lead]>} Distinct [Project Lead],';')

[Apfelbaum]

Hey, thank you very much for your solution! It works! I did not even know that there is a function P() in the setexpression! 🙂 

I also found an alternate solution, which is to concat in a seperate field in the script. And then in the dashboards, in the tables you can use the concatenated field of the script, and for the filters you use the non-concatenated field.