Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Having trouble with my measure. It actually calculates the correct sum, but it doesn't show the amount for each product.
The idea is that we have 2 product tables, 1 is purely used to make a selection.
You select a product from this 1 selection table.
I then want to show the amount of items bought from orders that have bought item. E.g. you pick pants, i want to see what people who bought pants also bought.
I got my measure to actually calculate the total sum of products sold (23 in this little fictive model), but it only shows the value for the pants, not for each of the items.
I want each of the items to show like this:
Measure:
link to the datamodel: https://drive.google.com/file/d/17nV3F48UXhsvJSWv7DiB7zdm7tojTPlA/view?usp=sharing
Solved! Go to Solution.
Actually found a solution i could get to work:
https://community.powerbi.com/t5/Desktop/DAX-Function-for-Customers-also-bought/m-p/147454
Actually found a solution i could get to work:
https://community.powerbi.com/t5/Desktop/DAX-Function-for-Customers-also-bought/m-p/147454
@AlexaderMilland , are you looking for Market Basket Analysis?
refer if needed
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/
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |