How often are two (or more) items sold together sorted by order number

[Anonymous]

Hello guys 

I'm somewhat new to PowerBI. Apologies in advance if this question or a similar one has been asked already. Basically, as the title suggests, I'm attempting to find out how often two (or more) items are sold together in a single order. 

Additionally, this will then be used to determine whether two items should be moved closer together location-wise in the warehouse. 
Bellow is a screenshot of a sample of the data: 

Location = the location of the ware in the warehouse
WareID = the ID of the ware 
Order number = the order 

I'm thinking that these are the only collumns that are relevant, but let me know if additional data is needed, etc. 

Best regards, 
Sebastian 

[amitchandak · Accepted solution]

@Anonymous , I think you are looking for Market Basket Analysis
https://finance-bi.com/power-bi-basket-analysis/
https://businessintelligist.com/2017/03/27/market-basket-analysis-using-power-bi/
https://www.daxpatterns.com/usecases/market-basket-analysis/
https://www.mssqltips.com/sqlservertip/5428/market-basket-analysis-in-r-and-power-bi/

[Anonymous]

This is exactly what I'm looking for. Thanks for replying!