Filter combination

[pmargari]

Hello all, 
I wonder if any of you could give some tips how can I solve the following:

In my sales table I have 3 team leaders , because of each phase of the sale process , lets call it Phase A, B and C , and some team leaders could have menbers in more than one phase. 

I would like to have in one report the 3 phases and a unique filter that could filter all the reports correctly , any idea how can I create a filter that will combine this 3 team leaders fields ? 

TL_A  &  TL_B  & TL_C      -----Unique Filter---------> Team leader 

Thanks a lot for your inputs !
Paulo 

 

[AnkitKukreja]

Hi! @pmargari 

Try using a dax function union. It will help you combine your leads.

https://docs.microsoft.com/en-us/dax/union-function-dax

[pmargari]

Hello Ankit 
Thanks for your reaply , but this fields are in the same table .... 

KR
Paulo

[AnkitKukreja]

Hi! @pmargari 

Can you please share some sample data and your expected result?