Completely baffled - row qty makes no sense

[Anonymous]

Hello Community  -  

The first line in the table shows a correct qty (QtyOrdered) of 1500.    This has been verified in our ERP system.   Note this is a system generated number and I did have to change the setting to "do not summarize".  

I had thought a simple SUM measure over the Qty ordered would give me the same answer...but it is returning 7500.   I tried a Count measure...same thing.    I tried a SUMX measure...same thing.  

The very confusing part, is that it is not happening to any of the other rows...only the first.   What on earth is going on?    And why is a measure formula not working to show the correct quantity.  

And there are no other lines...this is it.  

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[amitchandak]

@Anonymous , Not very clear. Can share the expected output.

Line level Qty =sum(Table[Qty Ordered])

Do you need order-level qty

calculate(sum(Table[Qty Ordered]),allexcept(Table, Table[Order]))

or

calculate(sum(Table[Qty Ordered]),filter(allselcted(Table), Table[Order] = max(Table[Order])))

[Anonymous · Accepted solution]

Thanks for everyone's input.  

The issue turned out to be that there were some duplicated rows and so the Order line was being multipled 5 times.  

[v-yiruan-msft]

Hi @Anonymous ,

Thanks for your feedback and sharing the cause of problem. Could you please mark your post as Answered since the problem has been resolved? It will help the others in the community find this solution if they face the same problem with you. Thank you.

Best Regards

Rena