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.
I had 3 tables. Each table contains one xxxx-ID column, which acts as key. Table 1 only contains unique values of xxxx-ID, while table 2 and 3 contain multiple occurences xxxx-IDs (duplicates). Table 2 for instance has a column called 'action' with about 20 different actions. An xxxx-ID can have more than one action, but an action always has one of the same xxxx-ID.
As I need to do some data validation I wanted to check how many of the xxxx-IDs from table 1 are also in table 2, for each 'action'. So I created a matrix visual. However, since I the results I got didn't make much sense, I added a new table (table 4) which contains a single column that has a single instance of all xxxx-ID in all three tables (so only unique xxxx-IDs).
Then, I created a new matrix visual to count the number of xxxx-ID per 'action' as shown below:
As you can see, the numbers still don't make sense. For each 'action' it shows the count of all the xxxx-ID's in table 4. While some actions occur with just a couple of dozen xxxx-ID's.
My relationships looks like this. Basically I have table 4 connected to the three other tables by key xxxx-ID (marked yellow):
Well, unfortnately, because you blurred everything out, it's impossible to figure out what is related to what and correlate that back to your results. Or, you have created a relationship that doesn't make any sense. You shouldn't need a fourth table.
Tough to really say without sample data, etc. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You've got a point there... With the screens I tried to give as much info, without exposing sensitive data. I'll see if I can add some sample data.
Hi @Chris64,
Since all the IDs in the table2 are in the table1, it seems the answer is the count of IDs in the table2. Right?
Best Regards,
Dale
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |