Group by based on DAX column

Question

I have 2 tables in the model. In the firsttable I bring a column from the second table using DAX function RELATED.

Talble 1:

Table 2:

And the first table after bringing another column:

Now I need a new table that will show me Order ID and the total amount:

I tried to do it in a few ways and non recognizes the new price column.

I tried to add a table in the following way:

Total Price per order = SUMMARIZECOLUMNS(Orders[Order ID], "Total Order Price", Orders[Price])

I get the following error:

A single value for column rpice in table Prders cannot be determined..

What am I doing wrong?

(couldn't find a way to attach the file..)

greg_deckler · Accepted Answer

Anonymous&nbsp;Try:&nbsp;Total Price per order =&nbsp;SUMMARIZECOLUMNS(Orders[Order ID],&nbsp;"Total Order Price",&nbsp;SUM(Orders[Price]))

Forum Discussion