Relationship between two tables not working

[Apeyy]

Hello,

I have 3 tables, table 1 contains the file number and fees, table 2 contains file number, working hours, year and company name. Table 3 contains unique file number to connect these two tables. Below are the tables and relationships.

 

However, when I create the matrix and trying to show bth the working hours and fees of the file number under a particular company, the values "fees" are all the same. I also tried to create a cluster column chart to show the fees and working hours of different companies but the fees are same for all companies.

How can I get different fees under the file number and company? Is there anything I'm missing for the relationship? Thank you!!

[v-jayw-msft · Accepted solution]

Hi @Apeyy ,

Just change the relationship from "single" to "both".

Best Regards,

Jay

[amitchandak]

@Apeyy , because the company is not common between two tables. only one table has that.

That is why is it not working.

Also common table only work if that is context

You can try like

Sumx(values(Table3[File]), calculate(sum(Table1[Fee])))

But I doubt this will make are the difference.

Also, prefer to share data in text format.