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.
I am trying to group two columns together to group the number of products purchased on the same transaction. I am using the summarize/Groupby functions to group the transaction number and the product name together. Then I will use this information to see how many specific items were purchased on a single transaction (Units and Gross). This is the formula I am using but I get the error mentioned in the title... I have tried everything and I get the same error. I am also using this as a measure, and when I tried to build it as a column it was the same error.
Concession Groupby :=
SUMMARIZE (
ConcessionSales,
ConcessionSales[ConcessionTransactionID],
ConcessionSales[ProductKey],
"Concession Groupby", SUMX ( ConcessionSales, ConcessionSales[Gross Amount] )
)
Any help would be greatly appriciated!!
Solved! Go to Solution.
Hi @bigman24
SUMMARIZE function will return a table, please create a new table to receive result.Below is the post for your reference.
https://community.powerbi.com/t5/Desktop/Summarize-DAX/td-p/297259
Regards,
Hi @bigman24
SUMMARIZE function will return a table, please create a new table to receive result.Below is the post for your reference.
https://community.powerbi.com/t5/Desktop/Summarize-DAX/td-p/297259
Regards,
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |