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(FACTSalesOrderTable,FACTSalesOrderTable[increment_id]))

 

Need Help

3 Replies

  • 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.