Unique shipping cost with same orders numbers

[mzucarelli]

Hello, 

I have a file with orders and their shipping cost.  There can sometimes be more than 1 line with the same order number and shipping cost.  

I need to only count the shipping cost for 1 of these items so the shipping cost doesn't increase when more lines are there. but i can't remove duplicates from the sheet

any ideas? 

[ValtteriN · Accepted solution]

Hi,

So what you want is a sum wit distinct conditions? Here is the basic pattern for that:

Data:

Dax:

Measure 10 = SUMX(

SUMMARIZE(ShippingDuplicates,ShippingDuplicates[PO],"Value",max(ShippingDuplicates[Cost])),[Value])

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[Anonymous · Accepted solution]

Hi @mzucarelli ,

According to your description, you want to keep only one row for each Customer with the same ShipDate,right?

If so, please try the following formula to create a new table:

New Table = DISTINCT( SELECTCOLUMNS('Table',"CustomerPO",[CustomerPo],"ShipDate",[ShipDate].[Date],"Shipping Cost",[Shipping Cost]))

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

[VahidDM]

HI @mzucarelli 

You can remove those duplicate rows with SUMMARIZE, but what is the final output? Do you want to sum the shiiping cost or you want to know the number of the orders?

New Table = SUMMARIZE(Shipping,Table[CustomerPO],Shipping[Shipping Cost])

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[ValtteriN · Accepted solution]

Hi,

So what you want is a sum wit distinct conditions? Here is the basic pattern for that:

Data:

Dax:

Measure 10 = SUMX(

SUMMARIZE(ShippingDuplicates,ShippingDuplicates[PO],"Value",max(ShippingDuplicates[Cost])),[Value])

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[mzucarelli]

Thanks for the reply, 

I tried that - there are no errors, but it doesn't product anything.  the visual will error.