cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bigman24 Frequent Visitor
Frequent Visitor

DAX SUMMARIZE/GROUPBY Error: Multiple Columns Cannot be Converted to a Scalar Value

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DAX SUMMARIZE/GROUPBY Error: Multiple Columns Cannot be Converted to a Scalar Value

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: DAX SUMMARIZE/GROUPBY Error: Multiple Columns Cannot be Converted to a Scalar Value

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.