dealing with two same dim columns

[Ehsan_Mirzaei]

Hi community
i have two columns with similar content. i am trying to build my model with two dim table and one fact table. the question is that should i make two similar dim table for these two columns.
e.g: columns

Country	Target 2	Target 3	Score
Japan	Red	Green	10
USA	Yellow	null	15
China	Green	Yellow	9

thank you

[pranit828 · Accepted solution]

Hi @Ehsan_Mirzaei 

You need to create two dim tables if you will be using it in a slicer or measure.