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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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