DAX error message

[BishwaR]

Hi

Folling DAX returns an error "This expression refers to a multiple columns, Multiple columns cannot be converteed to a scalar value"

Is there any way I can make it work ?

Thanks

A =
CALCULATE (
SUM( ' Committed Orders'[Sales Qty] ),FILTER(' Committed Orders',ALL(' Committed Orders')),

ALLEXCEPT (
' Committed Orders',
' Committed Orders'[Ship Branch],
' Committed Orders'[Item#],
' Committed Orders'[Order Date],
' Committed Orders'[Invoice#]))

[amitchandak · Accepted solution]

@BishwaR , Try like

A =
CALCULATE (
SUM( ' Committed Orders'[Sales Qty] ),ALLEXCEPT (
' Committed Orders',
' Committed Orders'[Ship Branch],
' Committed Orders'[Item#],
' Committed Orders'[Order Date],
' Committed Orders'[Invoice#]))

or

A =
CALCULATE (
SUM( ' Committed Orders'[Sales Qty] ),ALL(' Committed Orders'),

ALLEXCEPT (
' Committed Orders',
' Committed Orders'[Ship Branch],
' Committed Orders'[Item#],
' Committed Orders'[Order Date],
' Committed Orders'[Invoice#]))