Forum Discussion
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.
1 Reply
- FreemanZSuper User
post some sample data will be very helpful