Forum Discussion

akashpadmakumar's avatar
akashpadmakumar
Helper I
5 years ago
Solved

Need help with Table Relationship

I have developed a Power BI Dashboard, with headcount table, joiners and leavers for a month. The dashboard was working fine when I had just one month data on the dashboard (June) , now since I have...
Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    Is the New Joiners table expected to have duplicate values?

    I mean how can an employee join twice, once in june and other in July?

    If it is acceptable as per your data model, then you would have to look for some other field to create a relationship on.

    Or else, create a bridge table with all the unique values of employee between New Joiner and Headcount and create a relationship of the two tables with the bridge table.

    It's always better to have information related to employee in a separate table.

aj1973's avatar
aj1973
Community Champion
5 years ago

Hi akashpadmakumar 

Try changing the direction of the relatioship to both.

  • akashpadmakumar's avatar
    akashpadmakumar
    Helper I
    5 years ago

    I did try that, but it is not working

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      In that case I don't see why you are pointing that the cause is the relationship! Did you open power query and check for issues? Then did you DAX? Are your DAX formula correct? You see it could be different causes. 

      • akashpadmakumar's avatar
        akashpadmakumar
        Helper I
        5 years ago

        The graphs where showing all correct values until I put in July month data appended to june data, this obviousl ywill have duplicte values and the values are not showing correct after that. I can attach the visuals as well. 

        The Dax calculations are all correct