Forum Discussion
Filter
Is it possibile in dax to apply a filter referring to another table? Like that:
hi, Anonymous
Yes, you could.
and I think what you need is RELATED or RELATEDTABLE in the calculation. (The relationship between the two tables must already be established )
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/relatedtable-function-dax
Best Regards,
Lin
2 Replies
Create a new column in your table. This one created in item table using sales tables
Maxx(filter(sales,Sales[item_id]='Item'[Item ID]),Sales[Order Id])
hi, Anonymous
Yes, you could.
and I think what you need is RELATED or RELATEDTABLE in the calculation. (The relationship between the two tables must already be established )
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/relatedtable-function-dax
Best Regards,
Lin
