Forum Discussion
Sales Analysis
Hi StevenDB
It is great that you are getting into BI and Power BI.
What I would suggest is when getting your data to only bring in the fields that you currently need. To simplify the process as you are just starting out.
So that would be:
-Unique Code
-Different Product Categories
-Number of Articles
-Price of Articles
-Date Info
Start with that and put that into your Power BI Model.
Once you have the above you should then be able to put the Unique Code on a Slicer, and have all the other details in a table. And when you click on a Unique Code you can see which items they bought, as well as the product categories.
Hello guavaq,
Thank you for the effort but this is not what I am looking for. I could work this way but not in this case. The reason is that there are just too many unique codes to be able to use as a slicer or filter. This year alone there are already more than 108.000 unique codes.
I started with a DISTINCTCOUNT on these codes which helps me to group them by categorie. That is a start but this only tells me how many codes (customers) have bought something from the selected category. With this I get no information on the other categories.
I'm thinking that I shoud work with a Category-slicer, since there are only about 20 of them.
Maybe I can rephrase the question to something like "x (number or percentage) of the unique codes (= customers) that bought category A also bought category B (and/or C, and/or,....)"
.
