Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Convert Calculated Column measure formula error

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(FACTSalesO...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

checking the second formula amit...and thanks