Forum Discussion

Apeyy's avatar
Apeyy
Regular Visitor
4 years ago
Solved

Relationship between two tables not working

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 tab...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Apeyy ,

     

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

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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.