Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |