Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mapping between four table

Hi, I have four type of tables and I must map them to get count result for reporting but I have issues about it. Please help me on solving this problem. First I want to show you my minimal design thi...
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Just want to check if you have got any relationships between these tables set-up in Power BI?

If yes, can you share screenshot on the data model please?

 

Thanks,

Pragati

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    Yes sure this is my data model, I already merged tables and already done with this but I need help on modeling report like my excell file.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      6 years ago

      Based on your business logic follow the filter direction arrows in your data model and see if they allow you to apply the desired filters.  Adjust the direction as needed.