Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |