Group and Subgroup table using non unique values

[fva6937]

Sorry, couldn't even figure it out the correct vocabulary to ask 😞

I have a product table from the server that looks like this:

Product Table

Group, Subgroup, and Subsubgroup are separate tables used to characterize the product.

Group Table

Subgroup TableSubsubgroup Table

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? 🙂 

[MarkLaf · Accepted 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.

[fva6937]

It worked! Thanks!!

The IDs are two digits. How do I add delimiters?

[MarkLaf]

The example DAX I provided is already inserting | as delimiters. That's the '&"|"&' portion between the column references.