Intersect on Table based on multiple row values

[DeeBali]

Hello Fabric Community,

Need assistance with another problem i am stuck at. I have a table SMB that has Columns Name, Email, Department, Event. 
Event coumn values: Event1,Event2,Event3 etc..
So Name, Email and Department coulmns are connected to multiple type of Event data. I have created a slicer by "Event" coulmn and that shows the data is a table base on each event, or if select multiple options, it will show data for multiple events together.  What I am attempting to do create a measure that will display the data as a intersect between the different Event values. So I need to display Name, Email, Department information only for rows only if they have all 3 events from Event Column. 

How can I go about doing this? I rsearched the forum but did not find anything similar to my issue. Unless this is not possible and I may need to approach it some other way? Thank you. 

[FreemanZ]

post some sample data will be very helpful

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...