Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi,
i am doing 25 days challange from curbal and i am on day 15:
https://curbal.com/25-days-of-dax-fridays-challenge
and i have issues with code provided in solution which is:
for me it is throwing error:
it is only working with Products[ProductID].
Can anybody explain why in simple plain english?
Please help,
Best,
Jacek
Solved! Go to Solution.
In the QPurchases variable, the FILTER function is not being applied to the Orders table, it is being applied to the temporary table created by SUMMARIZE. If you try to filter on [Product ID] rather than Orders[Product ID] then that should work, as it is filtering the column from the temporary table.
Another way to do it would be to move the FILTER call inside the SUMMARIZE, so
SUMMARIZE( FILTER(Orders, Orders[Product ID] = 11 ), rest of SUMMARIZE statement
In the QPurchases variable, the FILTER function is not being applied to the Orders table, it is being applied to the temporary table created by SUMMARIZE. If you try to filter on [Product ID] rather than Orders[Product ID] then that should work, as it is filtering the column from the temporary table.
Another way to do it would be to move the FILTER call inside the SUMMARIZE, so
SUMMARIZE( FILTER(Orders, Orders[Product ID] = 11 ), rest of SUMMARIZE statement
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |