Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

incorrect total for DAX measure

Hi all

 

I have two dax measures returning the incorrect total.

 

The dax is:

 

 

 

Measure 1

 

Total_Order_Measure = CALCULATE(FactSalesOrderLine[Order_Amount >0],ALLEXCEPT(FactSalesOrderLine,FactSalesOrderLine[SalesOrderNumber]),FactSalesOrderLine[Shipping_Datediff] >= 0)

 

 

Measure 2

 

Total_weighted_avg = CALCULATE([Sales_Order_Weighted_Avg_v2],ALLEXCEPT(FactSalesOrderLine,FactSalesOrderLine[SalesOrderNumber]))
 
How can I get these measure to show correct totals?
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Anonymous , Try a new measure on top of your measure

     

    Sumx(Values(FactSalesOrderLine[SalesOrderNumber])), [Total_Order_Measure])

     

    Ideally using values or summarize(for more than one column, you should use all the columns in visual