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.

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

PietroP , Try like

NewColumn = calculate (sumx(values(Table2[Sitecode]),calculate(Max(Table2[TotKW]) )))

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • PietroP's avatar
    PietroP
    New Member
    4 years ago

    Thank you for your suggestion. It didnt work, I still have the same total.

    I updated my first post pasting real datas about the two tables. Hope it could help.

    Tell me if you need anything different.

    Thanx