***** Related Links ***** Basket Analysis Example - Power BI Advanced Analytics blog.enterprisedna.co/advanced-basket-analysis-example-in-power-bi-cross-selling/ Basket Analysis Introduction - Best Practice Tips For Power BI blog.enterprisedna.co/basket-analysis-introduction-best-practice-tips-for-power-bi-using-dax/ Discover Multiple Product Purchases Using DAX In Power BI blog.enterprisedna.co/discover-the-amount-of-customers-who-purchase-multiple-products-w-power-bi/ ***** Related Course Modules ***** Unique Analytical Scenarios portal.enterprisedna.co/p/unique-analytical-scenarios DAX Formula Deep Dives portal.enterprisedna.co/p/dax-formula-deep-dives Mastering DAX Calculations portal.enterprisedna.co/p/mastering-dax-calculations ***** Related Support Forums ***** Cross Selling Show Case forum.enterprisedna.co/t/cross-selling-show-case/765 Top 10 Matrix Cross Selling forum.enterprisedna.co/t/top-10-matrix-cross-selling/1790 Common Purchased Items forum.enterprisedna.co/t/common-purchased-items/345 For more cross selling queries to review see here….. forum.enterprisedna.co/search?q=cross%20selling
Hi @user-ol1dl4uc4w, Unfortunately, no it's not possible to create a drill-through for this analysis. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our RUclips channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/
Great video. Im stuck trying to do an analysis where a customer who bought a specific product, didnt buy another specific product. If you can make a video on the subject or help me with some insights, it would be great! Thanks
Hey Sam, To find all customers who say, "purchased product 1, but not product 2", would you just substitute the EXCEPT() function for INTERSECT()? Thanks, Alp
This is wonderful. just I wanted to know is there any possibility to have the intersect value of customer combinations. I tried adding but it gives the data either for Row/Column.
Hi Sam,you could do an experiment if between the law of benford and abc de pareto have some impact that is not visible to the naked eye in the behavior of sales in general
How we can add a row in a matrix using slicer? Example we have category A in a matrix in row (as default category in matrix - default when no category is selected in slicer), now we select category B in slicer then values for A should go and only B should be there. When we select more than one category in slicer, then there should be new rows added to the matrix. So total rows in matrix is equal to number of categories selected in column.
Hi said, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hi @Sam , your video and tutorial looks fantastic , really appreciated all your videos. But this one , may i get further understand ? What're you doing here ? I still dun get why blank on Product 1 or 2 or 3 etc.... and has the number on other products instead. your analysis quite awesome to me. I'm your fan :)
Hi Wajiha Rehman, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks! portal.enterprisedna.co/
***** Related Links *****
Basket Analysis Example - Power BI Advanced Analytics
blog.enterprisedna.co/advanced-basket-analysis-example-in-power-bi-cross-selling/
Basket Analysis Introduction - Best Practice Tips For Power BI
blog.enterprisedna.co/basket-analysis-introduction-best-practice-tips-for-power-bi-using-dax/
Discover Multiple Product Purchases Using DAX In Power BI
blog.enterprisedna.co/discover-the-amount-of-customers-who-purchase-multiple-products-w-power-bi/
***** Related Course Modules *****
Unique Analytical Scenarios
portal.enterprisedna.co/p/unique-analytical-scenarios
DAX Formula Deep Dives
portal.enterprisedna.co/p/dax-formula-deep-dives
Mastering DAX Calculations
portal.enterprisedna.co/p/mastering-dax-calculations
***** Related Support Forums *****
Cross Selling Show Case
forum.enterprisedna.co/t/cross-selling-show-case/765
Top 10 Matrix Cross Selling
forum.enterprisedna.co/t/top-10-matrix-cross-selling/1790
Common Purchased Items
forum.enterprisedna.co/t/common-purchased-items/345
For more cross selling queries to review see here…..
forum.enterprisedna.co/search?q=cross%20selling
Amazing. Is it possible to do a drill to see who is the customers? How?
Hi @user-ol1dl4uc4w,
Unfortunately, no it's not possible to create a drill-through for this analysis.
For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out!
If you haven't yet, do subscribe to our RUclips channel and LinkedIn group to keep posted on the latest data skills and tools updates.
Hoping you find this useful!
Cheers,
Enterprise DNA
forum.enterprisedna.co/
www.youtube.com/@EnterpriseDNA
www.linkedin.com/groups/12004506/
Can you show me the formula: "% Purchased Both"?
Tks, fantastic video :)
Great video. Im stuck trying to do an analysis where a customer who bought a specific product, didnt buy another specific product. If you can make a video on the subject or help me with some insights, it would be great! Thanks
Hey Sam,
To find all customers who say, "purchased product 1, but not product 2", would you just substitute the EXCEPT() function for INTERSECT()?
Thanks,
Alp
This is wonderful. just I wanted to know is there any possibility to have the intersect value of customer combinations. I tried adding but it gives the data either for Row/Column.
Hi Sam,you could do an experiment if between the law of benford and abc de pareto have some impact that is not visible to the naked eye in the behavior of sales in general
How we can add a row in a matrix using slicer? Example we have category A in a matrix in row (as default category in matrix - default when no category is selected in slicer), now we select category B in slicer then values for A should go and only B should be there. When we select more than one category in slicer, then there should be new rows added to the matrix. So total rows in matrix is equal to number of categories selected in column.
Gold
Hi said, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hi @Sam , your video and tutorial looks fantastic , really appreciated all your videos.
But this one , may i get further understand ? What're you doing here ? I still dun get why blank on Product 1 or 2 or 3 etc.... and has the number on other products instead.
your analysis quite awesome to me. I'm your fan :)
Check out the replays of full sessions here - enterprisedna.co/enterprise-dna-learning-summit-november-2018-session-replays/
@@EnterpriseDNA Hello! I am interesting of the full video but the link is down. Is there another link? Thanks!
Hello, Does anyone have the dataset and pbix file for this?
Thanks.
Hi Wajiha Rehman, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks!
portal.enterprisedna.co/
@@EnterpriseDNA Thank u :)