Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to use data fields from indirectly related data tables and build a table visual in Power BI?

I have the data model as follows: SamJam has keys from both the tables Sam and Jam. That way a Many-to-Many relationship is established between Sam and Jam through SamJam. Jam is related ...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    Could you have tried to modify the relationship between Jam and Pam from single to both? If it could not help you, could you please share a sample file to have a test if possible?

     

     

    Regards,

    Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-danhe-msft ,

I'm afraid I have tried it and it does not work.

Thanks!

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous ,

Could you please share your pbix file to have a test if possible?

 

Regards,

Daniel He