slicer to filter same email Present in different Campaign BU's

[Kushagra05]

Hello All,

I am having below table. which contains email Present in two different BU's, when I select both digital marketing and media in slicer it's giving me all the records Present in both BU's ( full outer Join) , I want to display just same email present in Digital marketing and media ( example abc, abc and cde, cde)

I tried to flag it using

SameEmailFlag = VAR __c = CALCULATE ( DISTINCTCOUNT ( Table[bu_campaign] ), ALLEXCEPT ( Table, Table[email]) )

RETURN

__c > 1

I am getting True or false ( Can add it as table) , How can i create a slicer when i select both DMedia and Dmarketing , Only same email present in both Bu's should get filtered. can anyone help me with it( Power Bi)

capmain BU	email
Digital marketing	abc
digital media	abc
Digital marketing	cde
digital media	cde
Digital marketing	efg
digital media	igh

[v-cgao-msft · Accepted solution]

Hi @Kushagra05 ，

Please try add a visuals filter:

SameEmailFlag = 
VAR __c = CALCULATE(DISTINCTCOUNT('Table'[capmain BU]),ALLEXCEPT('Table','Table'[email]))
RETURN
IF(__c > 1,"Y","N")

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group