Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
baijumohan1990
Helper II
Helper II

Display Matched and Non Matched Values based on a slicer value

 I am working on a Viewership table which tells which customer watches which asset.  Based on the asset filter, I need to display the customers who watched the show & customers who didn't watched the show. below is my example tablevwship1.PNG

 

If the asset_id selected as 1 in the slicer, the desired output will be as below

 

                                                         result1.PNG

I have tried creating a cross-join table with asset_id and customer_id , but that approach taking much time with large data.  Request the experts here to suggest the best optimal solution to achieve this. 

 

thanks

bm

2 REPLIES 2
parry2k
Super User
Super User

@baijumohan1990 to clarify, first image in your post shows how your data table is, correct?

 

And you are using asset slicer from column asset , correct?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Yes

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.