DAX help

Question

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 the&nbsp;customer reference number is same, then max of&nbsp;sales order quantity.Please help.

vivran22 · Answer

Anonymous&nbsp;&nbsp;Can you please help us with sample data along with the expected output?&nbsp;Regards,Vivek

anonymous · Answer

vivran22 · Answer

Hey Anonymous,&nbsp;Thanks for sharing, but it is still not very clear from the conditions you have mentioned and the output you are looking for. How you are arriving at the Output ?&nbsp;Cheers!Vivekhttps://www.vivran.in/Connect on LinkedIn&nbsp;&nbsp;

anonymous · Answer

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

dax · Answer

Hi&nbsp;Anonymous&nbsp;,
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])
&nbsp;
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.
&nbsp;

Forum Discussion

DAX help

7 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX