Forum Discussion
Issue Presenting Data
Hi DAX0110 - it's the count of products within the hierarchy that have reached particular thresholds of sales (be able to split the number of products in the hierachy based on how well they're performing as a percentage of the overall hierarchy sales value for a given month) - for actual sales data for the individual SKUs I have the raw data, so it's not required in my Power BI dash
Do you want a separate count for products that have no sales record at all for the month? Or is it OK to include it in the count of bottom-5% products?
Finally, can you take a screenshot of the relationship view of your data model and post it?
Hi DAX0110,
I'd like SKUs with no sales to have their own count / split out from those on < 5%
So the relationship between the two data tables is a one to many ('Master Data'[Material Number] to 'Sales'[Material Number]). I do have a third data table which is mapping for my product groupings. the rationship is many to one ('Master Data'[hierarchy 1] to 'Hierarchy'[Hierarchy 1) as the grouping I want is further down the hierarchy than then Main master data file drills into.
hope that makes sense?