Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

sum a column value based on another table column

I have a table1 with 2 columns A & B which has value like below  A             B p1 1 p1 3 p2 4 p7 6   Another table 2 with column A A p2 p3 p6 p8 p10 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    After modification it works . Thanks Amitchandak .

    measure=
    var _tab = except(selectcolumns(Table1,"col",Table1[A]),selectcolumns(Table2,"col",Table2[a]))
    return
    calculate(sum(Table1[b], filter(Table1,Table1[A] in _tab))

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

Anonymous , Try a measure like

 

measure=
var _tab = except(allselected(Table1[A]),allselected(Table1[b]))
return
calculate(countrows(Table1), filter(Table1,Table1[A] in _tab))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for such a quick response , I made a little modification to make it work but the problem is it does not work properly when filter is applied 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    After modification it works . Thanks Amitchandak .

    measure=
    var _tab = except(selectcolumns(Table1,"col",Table1[A]),selectcolumns(Table2,"col",Table2[a]))
    return
    calculate(sum(Table1[b], filter(Table1,Table1[A] in _tab))