Filter combination

Question

Hello all,&nbsp;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.&nbsp;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 ?&nbsp;TL_A&nbsp; &amp;&nbsp; TL_B&nbsp; &amp; TL_C&nbsp;&nbsp; &nbsp; &nbsp;-----Unique Filter---------&gt; Team leader&nbsp;&nbsp;Thanks a lot for your inputs !Paulo&nbsp;&nbsp;

ankitkukreja · Answer

Hi!&nbsp;pmargari&nbsp;&nbsp;Try using a dax function union. It will help you combine your leads.https://docs.microsoft.com/en-us/dax/union-function-dax&nbsp;

pmargari · Answer

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

ankitkukreja · Answer

Hi!&nbsp;pmargari&nbsp;&nbsp;Can you please share some sample data and your expected result?&nbsp;

Forum Discussion

Filter combination

3 Replies

Related content

Tables combine

Filter combinations

Combined conditional filtering

Data Combining Problem

Combine Column