Forum Discussion

mhusaein's avatar
mhusaein
Regular Visitor
3 years ago
Solved

create calculated column based on 3 tables

      i have 3 tables as follows  table 1 :    table 2 :      table 3 :    i need to get the sum of table1[value] and instert it as a column in table[3] as i will make ex...
  • tamerj1's avatar
    tamerj1
    3 years ago

    mhusaein 

    Please try

    CalculatedColumn =
    SUMX (
    FILTER (
    CALCULATETABLE ( table1, CROSSFILTER ( table2[type], table3[type], BOTH ) ),
    table1[id] = table3[id]
    ),
    table1[value]
    )