Dax Formula

[Anonymous]

Hi

    I need help for resolve this error .I am getting error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."  for using  this formula "Column = GROUPBY(Orders,Orders[Category],Orders[Sub-Category],"Total",SUMX(CURRENTGROUP() , Orders[Sales]))"

Thanks.

[Anonymous]

Hi Lydia,

        Thank you for your help.

Thanks.

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Please click "New Table" under Modeling ribbon, and apply your dax.



Regards,
Lydia