Forum Discussion
Issue Presenting Data
Hi mclougb6, just to clarify your requirements.... what final outcome do you want exactly? Just the count of products as you mentioned, or would you like to identify the products by name? Or do you want to show the per-product sum of sales as well?
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?
What I need to know is the names of all the relevant columns - eg, the sales amount column - the relationship view should show these names