Intersect on Table based on multiple row values

DeeBali — Fri, 15 Mar 2024 01:50:11 GMT

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.

Re: Intersect on Table based on multiple row values

FreemanZ — Fri, 15 Mar 2024 02:15:32 GMT

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-Forum/ba-p/963216

topic Re: Intersect on Table based on multiple row values in DAX Commands and Tips

Intersect on Table based on multiple row values

Re: Intersect on Table based on multiple row values