Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Hi, @Thackeb
Need to use DAX with selectedvalue func. can you provide demo pbix file? It would be easy to help you then.
Proud to be a Super User!
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 | ||