new measure group by from two tables

[Anonymous]

Hello guys,

This is my first project with PowerBI. here is my problem, I have two related tables as you can see below. 

I want to make new measure to get total sales(ordval) from orders table per weekdays (wkd) from the datum table. 

This is the formula 

new measure = GROUPBY (orders,datum[wkd],"sales by wkd",SUMX(CURRENTGROUP(),orders[ordval]))

 and this is the error

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

For your formula, GROUPBY (<table>, [<groupBy_columnName1>], [<name>, <expression>]… )

Group by returns a table with the selected columns for the groupBy_columnName arguments and the grouped by columns designated by the name arguments.

So it is used to create a new table, not a new measure.

https://docs.microsoft.com/en-us/dax/groupby-function-dax

For a measrue, you could just use this simple formula,

Measrue = CALCULATE(SUM(orders[ordval]))

Then drag datum[wkd] and this measure into a visual.

Best Regards,
Lin

[Anonymous]

Thank you guys

---