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.
Sorry, couldn't even figure it out the correct vocabulary to ask 😞
I have a product table from the server that looks like this:
Group, Subgroup, and Subsubgroup are separate tables used to characterize the product.
I'm not able to relate all of them due to the non-unique values. (there is no empty cell)
Any thoughts on how to make this work? 🙂
Solved! Go to Solution.
Add calculated columns that concatenate the IDs to get keys you can create a relationship on. If the IDs might be more than 1-digit ever, be sure to add delimiters.
I.e.
Subgroup Key = [Group ID]&"|"&[Subgroup ID]
Subsubgroup Key = [Group ID]&"|"&[Subgroup ID]&"|"&[Subsubgroup ID]
Note that you shouldn't have a problem creating relationship to the Group table with just [Group ID] - it's only the other two you have to do the above for.
Add calculated columns that concatenate the IDs to get keys you can create a relationship on. If the IDs might be more than 1-digit ever, be sure to add delimiters.
I.e.
Subgroup Key = [Group ID]&"|"&[Subgroup ID]
Subsubgroup Key = [Group ID]&"|"&[Subgroup ID]&"|"&[Subsubgroup ID]
Note that you shouldn't have a problem creating relationship to the Group table with just [Group ID] - it's only the other two you have to do the above for.
It worked! Thanks!!
The IDs are two digits. How do I add delimiters?
The example DAX I provided is already inserting | as delimiters. That's the '&"|"&' portion between the column references.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |