Convert Calculated Column measure formula error

[Anonymous]

Hi Experts

How could i amend the current measure which work fine in IMPORT mode - to work in DIRECT QUERY Mode...

AOV = CALCULATE(SUM(FACTSalesOrderTable[Gross_Order_Value]),ALLEXCEPT(FACTSalesOrderTable,FACTSalesOrderTable[increment_id]))

[amitchandak]

@Anonymous , This should work as a measure in direct query , are you facing any issue

AOV = CALCULATE(SUM(FACTSalesOrderTable[Gross_Order_Value]),

ALLEXCEPT(FACTSalesOrderTable,FACTSalesOrderTable[increment_id]))

or

AOV = CALCULATE(SUM(FACTSalesOrderTable[Gross_Order_Value]),

filter(allselected(FACTSalesOrderTable),FACTSalesOrderTable[increment_id] = max(FACTSalesOrderTable[increment_id])))

[Anonymous]

hi AMit i am getting the following error usinf forst measure and the second measure give the wrong end result.

[Anonymous]

checking the second formula amit...and thanks