Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX help

I have one scnario, First case, If the Sales Order number is same, customer reference number is different, then sum of sales order quantity. Second case, if the sales order number is different, and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

dax's avatar
dax
Community Support
6 years ago

Hi Anonymous ,

I am not clear about your logic, I use below measure to get your result, if this is not waht ypu want, please correct me and expian your logic in details(how to get 100 for last two rows)

Measure = CALCULATE(MAX('Table'[quantity]), ALLEXCEPT('Table','Table'[item],'Table'[customer]))
Measure 2 = SUMX(SUMMARIZE('Table','Table'[item],'Table'[customer],"MAX",MAX('Table'[quantity])),[MAX])

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    IF the Sales Order is same and Customer reference is same, then I took sum of quantity.

    (Here Customer reference number is Purchase order id only) 

    IF the Sales Order is different and Customer reference is same, then I took maxquantity.

    (If we failed to deliver Sales Order quantity, then we will create another Sales Order for remaining quantity).

    So my requirement is to show quantity item, item-variant and customer level.

    Please help

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    As you can see, SO number is different, but customer reference number is same. So the SO created again, for the remaining quantity 50.

    Still the actual SO quantity is 100.