Forum Discussion
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 ...
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))
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
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))