Forum Discussion

mclougb6's avatar
mclougb6
Frequent Visitor
8 years ago

Issue Presenting Data

Hi all,   Relative newbie to PowerBI and I'm having trouble using visualisations to present my data in a particular way.   In one Data table I have:    - A Master Data File containing data pert...
Need Help
Tutorial Requests
mclougb6's avatar
mclougb6
Frequent Visitor
8 years ago

Hi Dax0110,

 

thanks for your reply. your high level model is exactly what I'm looking to do ... I just don't know how to translate this into a PowerBI measure to give the desired output.

 

Essentially All I have are by data tables and the relationships between them connected - but the formulae / DAX wording is brand new.

 

Hoping someone can write out the measure for me / step by step what I need to do to model the raw data appropriately.

 

thanks,

B

 

DAX0110's avatar
DAX0110
Resolver V
8 years ago

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?

 

  • mclougb6's avatar
    mclougb6
    Frequent Visitor
    8 years ago

    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

     

     

    • DAX0110's avatar
      DAX0110
      Resolver V
      8 years ago

      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?

       

       

      • mclougb6's avatar
        mclougb6
        Frequent Visitor
        8 years ago

        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?