Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have 2 tables I'm attempting to link together through a middle table with unique values which are people's names. I took the names from both tables, appended the tables, and removed duplicates so they only appear once. Now I am attmepting to establish a relationship from either table to this link table I've created and I'm still unable to. How can I connect two tables that have mulitple names multiple times? The bottom table only has each name appear once so I don't know what else the issue could be:
Solved! Go to Solution.
Well, first thing to do is to check if this is the problem. Create two measures and display them in card visuals:
Measure 7 = COUNT('Table10'[Text]) Measure 8 = DISTINCTCOUNT('Table10'[Text])
If you get different values, you have an issue.
Then, typically what you do is to go into Power Query and do a Trim and Clean before your remove duplicates. It is often handy to sort the column in the model and visually inspect.
You can figure out what values are duplicated by doing this:
Table = SUMMARIZE(Table10,Table10[Text],"Count",COUNTROWS(Table10))
Generally this is a matter of what M considers a duplicate and what DAX considers a duplicate. Often there are trailing spaces, capitalization issues, etc. that M doesn't consider duplicates but DAX does.
@Greg_Deckler Is there any way to check for this to see where the discrepanices may be?
Well, first thing to do is to check if this is the problem. Create two measures and display them in card visuals:
Measure 7 = COUNT('Table10'[Text]) Measure 8 = DISTINCTCOUNT('Table10'[Text])
If you get different values, you have an issue.
Then, typically what you do is to go into Power Query and do a Trim and Clean before your remove duplicates. It is often handy to sort the column in the model and visually inspect.
You can figure out what values are duplicated by doing this:
Table = SUMMARIZE(Table10,Table10[Text],"Count",COUNTROWS(Table10))
@Greg_Deckler Worked perfectly! Setting up the cards showed a count of 29 and distinct count of 30. The culprit was a null value in the count of 30. Once I removed that null value in the editor, all was good. Thanks again!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |