Forum Discussion

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Eliminate Many 2 Many Relationship

Hi,   I am facing the issue while building many 2 many relationship, so far it works well when I want to display sales vs actual as per month, location, but when it comes down to customer codes, I ...
Need Help
Show and Tell
Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Hi amitchandak can you help me resolving the issue, I will share you the pbix, let me know if it will be possible for you to look into this

amitchandak's avatar
amitchandak
Super User
6 years ago

Anmolgan , share the pbix, I will try to check

  • Anmolgan's avatar
    Anmolgan
    Post Prodigy
    6 years ago

    Hi amitchandak, I have shared the PBIX link for the report, let me know if you can access it.

    • Anmolgan's avatar
      Anmolgan
      Post Prodigy
      6 years ago

      Hi amitchandak any issues while accessing the file?

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        Anmolgan ,

         

        I looked at it. The complete data model needs to re-looked. You need common dimension for the customer, dealer, Material, Geography, plant, and sales group.

        One or more than one member can be there in each of these. My advice would be that get correct data from the source. Creating a dimension here is not a great idea.

        Like Geography might start from city or store, depend on the common data point. Both tables seem to have a different column for material that needs to be addressed.