DAX query to filter search

sgmanjunath — Tue, 31 Jan 2023 14:50:16 GMT

Hi,

we will have 2 different columns one with the Primary email id and another column with multiple email id's of the same person(the reason for multiple email id's is a contingent employee with one email id and once the contingent employee becomes a permanent employee the email id will be changed) so basically, employees both emails are being tracked in our database.

Now, in the slicer when we search for an employee we need see all the email id's. but when we select the employee email we need to display only the primary email id as per below snapshot.

Can any one help with how can se implemented

Primary Email id	Multiple Email id's
Kaul, Sheetal <sheetal.kaul@hpe.com>	Kaul, Sheetal <sheetal.kaul@hpe.com>,<kaul@hpe.com>
Menon, Sheetal <sheetal.menon@hpe.com>	Menon, Sheetal <sheetal.menon@hpe.com>
R, Sheetal <sheetal.r@hpe.com>	R, Sheetal <sheetal.r@hpe.com>, <reena.s@hpe.com>
Katke, Sheetal <sheetal.katke@hpe.com>	Katke, Sheetal <sheetal.katke@hpe.com>,<talk@hpe.com>,<katke@hpe.com>

topic DAX query to filter search in DAX Commands and Tips

DAX query to filter search