Forum Discussion
numersoz
Helper III
Helper IIIDAX Filter A Table by Another Table
Hi, I have a table where I need to average out time stamped values. I want to filter this table by the product ID's contained in another table. Both the time stampped table and the other table con...
numersoz , Try like
calculate(sum(table1[Values]),filter(Table1, Table1[Product ID] in Values(Table2[Product ID])))
calculate(sum(table1[Values]),filter(Table1, Table1[Product ID] in allselected(Table2[Product ID])))or try treatas
amitchandak
Super User
Super Usernumersoz , Try like
calculate(sum(table1[Values]),filter(Table1, Table1[Product ID] in Values(Table2[Product ID])))
calculate(sum(table1[Values]),filter(Table1, Table1[Product ID] in allselected(Table2[Product ID])))
or try treatas
numersozHelper III
Helper III