Create a new column from other column

so, jlarques 

as i understand it works without type column because each product in your data source has the only category.

but when you add "type" column, you get a few rows with the same product and category but with different types

as you have a many-to-one relations it became impossible, because many product from Kit table have relations with many products from Kit Category

for my point, the best solution is to create in Kit table calculated column 

SurrogateKey = concatenate('Table'[Product];concatenate('Table'[Category];'Table'[Type]))

then try to build a master table:

KIT CATEGORY=
      DISTINCT(
                KIT[SurrogateKey]
       )

and create a relationship many-to-one by this SurrogateKey field

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin