Forum Discussion

DeeBali's avatar
DeeBali
Helper I
2 years ago

Intersect on Table based on multiple row values

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.