Create a list of items most often purchased with other items.

[Thackeb]

Trying to get the code built into Power Bi, but struggling. 

I have a list of orders with items. When an item is selected, I want to return the items that was most often purchased with that item.   It could also be what groups (product categories) was purchased. 

Thank you! 

[rubayatyasmin]

Hi, @Thackeb 

Need to use DAX with selectedvalue func. can you provide demo pbix file? It would be easy to help you then. 

[Thackeb]

Please see sample data and thank you so much!

RRIM_TRANS_NUM

Order Count

ITM_NUM

ITM_DSC

SUM_SHP_QTY

SUM_CST_OF_SAL_AMT

SUM_NET_SAL_AMT

CHNL_2_NM

CTGRY_1_DSC

CTGRY_2_DSC

CTGRY_3_DSC

CTGRY_4_DSC

PROD_CLS_DSC

PROD_CLS_DSC1

0159XWC

1

GOJ365912CT

SANITIZER,PURELL,ORGL,CLR

1

-45.78

56.43

OP RESELLERS

JAN SAN

HEALTH & PERSONAL CARE

PERSONAL CARE

HAND SANITIZERS

HAND SANITIZER GEL RTU

HAND SANITIZER GEL RTU

01622Z6

1

GOJ365912EA

SANITIZER,PURELL,ORGL,CLR

4

-15.26

16.65

OP RESELLERS

JAN SAN

HEALTH & PERSONAL CARE

PERSONAL CARE

HAND SANITIZERS

HAND SANITIZER GEL RTU

HAND SANITIZER GEL RTU

01622Z6

1

GOJ962504EA

SANITIZER,PURELL2LITER,CR

1

-16.1

17.45

OP RESELLERS

JAN SAN

HEALTH & PERSONAL CARE

PERSONAL CARE

HAND SANITIZERS

HAND SANITIZER GEL RTU

HAND SANITIZER GEL RTU

01623F8

1

GOJ965212CT

SANITIZER,HAND,PURELL,8OZ

1

-34.66

43.15

OP RESELLERS

JAN SAN

HEALTH & PERSONAL CARE

PERSONAL CARE

HAND SANITIZERS

HAND SANITIZER GEL RTU

HAND SANITIZER GEL RTU