Forum Discussion

CMoppet's avatar
CMoppet
Helper IV
1 year ago

Stuck Creating a SWITCH measure

Hello 😊   Please can I lean on this great community again to help me with a project I am working on?  I have attached sample data to demonstrate the issue I am having:  https://drive.google.com/fi...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

Please explain your data model.

Please read about normalization and star schemas.

  • CMoppet's avatar
    CMoppet
    Helper IV
    1 year ago

    lbendlin  Hello.  Thanks for taking the time to have a lookat this 🙂

    I have connected the columns that are common to both tables; Machine Brand, Type, Age Bracket, Market, Supplier.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      Those common columns must come from their own dimension tables.  Do not link fact tables, ever.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, CMoppet 

      Excuse me, did lbendlin 's answer solve your problem? If it has already been resolved, consider accepting him as a solution. Of course, if you have any solutions, you are also welcome to share.

       

      Based on my analysis of your data, it is also recommended that you rearrange the relationships between the data tables so that when you use the Hard or Soft column of the Repairs table as a slicer, you can also filter to the metrics related to the BaseSummary table.

       

      Here are the links to the mentioned stellate structures that I hope will be helpful to you:

      Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

      Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

       

      Please find the attached pbix relevant to the case.

       

      Best Regards,

      Leroy Lu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.