Forum Discussion

PietroP's avatar
PietroP
New Member
4 years ago
Solved

Wrong column total relationing two tables

Hi everyone, i have two tables:   table1: SiteCode, Work_ID, Date_Of_Work   ex: work_ID SiteCode date_of_work 2021CF000030 D03125 11/03/2021 00:00 2019CF000017 D00019 19/09/20...
  • Anonymous's avatar
    Anonymous
    4 years ago

    PietroP 

    You may just create a column in Table 1 to get the TOTKW from table2, this should be more clear to you.

    TOTKW = Related(table2[TOTKW])

     

    Then you can just create measure or column with simply sum.
    measure = sum(table1[TOTKW])

     

     

    Best regards
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

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

Hi PietroP 

 

Try this:

 

Measure = sum('Table 2'[TOTKW])
 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!