Forum Discussion
Solved
Filtering rows in one table by values from another table
Hi, relatively new user trying to complicate my own life with difficult tasks. lol. I need some help with filtering out rows from a data table (Table A) based on matching IDs from a lookup table (Ta...
I figured it out:
CALCULATE(sum(Table A[Total Cost]),EXCEPT(VALUES(Table A[Product_ID]),VALUES(Table B[Product_ID])))
