Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Is it possibile in dax to apply a filter referring to another table? Like that:
Solved! Go to Solution.
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
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
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])
User | Count |
---|---|
117 | |
75 | |
62 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |