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.
This is driving me nuts. Simple model for illustrative purposes:
Here is my GROUPBY():
Have tried this countless ways and watched endless YouTube video but cannot figure out why I am consistently getting this same error. Tried the SUMMARIZE() function and got the same error there too.
Grateful for any guidance. Thanks.
Larry
Solved! Go to Solution.
Are you trying to define a measure or a calculated column or a calculated table?
Your DAX returns a table with two columns (Region and SalesResults) and will give this error if you are trying to define something that isn't a table.
Trying to define a measure. That's the problem. Just re-tried as a "New Table" and it worked. Thanks very much!
Trying to define a measure. That's the problem. Just re-tried as a "New Table" and it worked. Thanks very much!
Are you trying to define a measure or a calculated column or a calculated table?
Your DAX returns a table with two columns (Region and SalesResults) and will give this error if you are trying to define something that isn't a table.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |