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.
Hi
I have Reporting Table that containes Customer IDs and a Customer Table that also contains Customer IDs.
I want to filter my Reporting Table to only show the Customers that exist in the Customer Table.
Can you please help???
Solved! Go to Solution.
It should be possible to pull the Customer ID field from the Customer table onto a visualisation and then add anything from the report table. This will only show records from customers that exist in both.
A DAX way to find a list would be something like
Table = FILTER(VALUES(Reporting[CustomerID]), CALCULATE(COUNTROWS(Customer) > 0))
This is a bit like an EXISTS query in SQL
Do you have a relationship linking the 2 tables on customer id?
Yes a many to many relationship
It should be possible to pull the Customer ID field from the Customer table onto a visualisation and then add anything from the report table. This will only show records from customers that exist in both.
A DAX way to find a list would be something like
Table = FILTER(VALUES(Reporting[CustomerID]), CALCULATE(COUNTROWS(Customer) > 0))
This is a bit like an EXISTS query in SQL
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |