Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

issues with relationships

So i am building a report that will showestablishment (number of empoloyees and FTE etc.) for areas in our service.   I have a list of all staff, their areas, position and their FTE on a sheet call...
Need Help
PVO3's avatar
PVO3
Icon for Impactful Individual rankImpactful Individual
4 years ago

I'm having a hard time trying to figure out what you are exactly looking for. I think you want to to filter by Area, Subteam and Job Role. 

 

Could you please share a screenshot of your data model with relevant fields & a desired result? 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

so the slicers filter the establishment data by those columns.

The allocated table (sheet3) has the same columns so i need those slices to also apply to that table. (i think)

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    Thanks for your screenshot. By the looks of it, you will problably encounter a lot of other issues in the near future. I would recommend to develop a star schema to have a solid foundation. Otherwise you'll be problem solving all kind of specific issues.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

     

    PVO3 is right.  A good model is half the battle, and Power BI prefers to use a star schema when modeling.

     

    Dealing with many-to-many relationships. This requires some modifications to the model to allow the filtering to pass correctly, which may affect calculated columns or measures etc. that have already been created. You could try creating DimTables for [Area], [Sub team], [Type] and create relationships with the 'Estimate' table.

    Many-to-many relationship guidance - Power BI | Microsoft Docs

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data