Showing filtered and non filtered data

[amcgrail]

Hello,

I have a data set that has customers and the products they have with a company. When I select a customer, my goal is to show what products they currently have with the company in one table, and what products they don't have in a different table. For example, if a customer has 5 products and the company has 8 unique products that they offer, I want to show a table of the 5 products the customer has, and another table of the 3 products they do not have.

Thank you,

Alex

[amitchandak · Accepted solution]

Can you try using except

https://docs.microsoft.com/en-us/dax/except-function-dax

Use one of the tables as full without the filter. And one having filters

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.