I was assigned to analyze a sales report and conduct a basket analysis for inventory management to discontinue some products. This experience transformed how I think about data and my approach to problem-solving.
Learn
Useful Resource
Selection Customers =
CALCULATE ([Unique Customers],
TREATAS(VALUES('SelectedItem'[ITEM]), 'Sales Line'[Item]))
Basket Analysis =
VAR v1 = SELECTEDVALUE('SelectedItem'[ITEM])
VAR v2 = SELECTEDVALUE('GeneralBasket'[ITEM])
VAR V3 = SELECTEDVALUE('AnalysisType'[Type])
VAR v4 =
SUMMARIZE(FILTER('Sales Line',
RELATED('Sales Line -Duplicate'[Item]) = v1),'Sales Line'[Order #])
VAR v5 = SUMMARIZE(v4,
'Sales Line'[Order #],
"Basket" , CONCATENATEX(RELATEDTABLE('Sales Line'), 'Sales Line'[Item], "|")
)
VAR v6 = SUMX(v4,1)
VAR v7 = SUMX( v5, IF(PATHCONTAINS([Basket], v2),1, BLANK()))
RETURN
SWITCH(TRUE(),
v1 <> v2 && V3 = "% Second Product is Purchased with First", DIVIDE( v7,v6, BLANK() ),
v1 <> v2 && V3 = "Count of Shared Baskets", v7,
v1 <> v2 && V3 = "count of first Product Purchase", v6,
BLANK () )
eyJrIjoiMDgyNDlkNjAtZGRjZS00NjE0LWEwZDktMTRkMWQwYWFjNTBiIiwidCI6IjNlMjFhMTFlLTc3MDctNDdmOC1iMzRhLTc5YTQ2YTQ0ZTk5MyIsImMiOjF9
Thanks
Dallas
