How to sum cells which are also present in mapping table?
Hi all, How do I create a measure that does the following: Sum table 1[column A] for all rows where table 1[column B] is equal to a value in table 2[column C] Right now I am writing it as: Measure 2 = Calculate(SUM(Table1[ColumnA]), Table1[ColumnB]=Table2[ColumnC]) But PowerBI is returning an error "The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression." In Excel, I would write this as: SUMIF(ColumnB, Table2'ColumnC', ColumnA) Please help. Thanks!