Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
2 years ago

Data Model suggestion for report building ?

Hi All,

 

I have a data model where I have fact DSR_DNQ with Skill Code (multiple) and dim Qualification also have multiple Qualification ID Integers for a single employee .

I need to link Qualifications witj DSR_DNQ to get it filter accorrding.

As they are Many Many relationship ? Is it recommended ?

How to resolve it?

 

 

 

Need Help

1 Reply

  • Wilson_'s avatar
    Wilson_
    Icon for Memorable Member rankMemorable Member
    2 years ago

    Hi ashmitp869,

     

    Based on your descriptions, one possibility is to make the relationship between Qualifications and emp bi-directional.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.