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.
Dear all,
I'm trying to compare a database (containing products sold to customers) with a standard of selling at each customer. I want to get all the products that were not sold to each customer: Database (minus) Standard. The relationship between the tables is Database (m) and Standard (1).
Thank you for your help
Daniel
@DanielChetrone , You want to create a new tbale
Use this kind of formula A -B (in A not in B )
except(distinct(client1[Client]) ,distinct(client2[Client]) )
But if you need this as measure, you need have common client table and use this measure with common client table
countrows(except(distinct(client1[Client]) ,distinct(client2[Client]) ) )
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |