false result in related tables report over non-unique value columns

[AtsPeets]

here are 2 tables related through an intermediate (unique value). tried to pick financial value from one table (column: eur) and match it with commodity groups in another table (column: "kaubagrupid").

the results seems to show, that something is wrong in relationship:

cannot figure it out, what do I miss here? thanks ahead.

arthur

[AtsPeets]

thanks for the hint, amitchandak! I think I understood. found a good explanation post about the concept of keeping separately dimension and fact data here: Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table - RAD...

[amitchandak · Accepted solution]

@AtsPeets , from where the Row/Column field are coming in Matrix, they should be from common dimension