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

[Anonymous]

I have the data model as follows:

The Data Model for the data set

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 to Pam by a One-to-Many relationship.

Sam and Pam do not have a direct relationship.

Now, when I try to create a basic table chart using SamName and Count of PamID, I get all the wrong values., i.e., all the values are shown as below.

The resulting table visual

How to get the exact Count of PamID by SamName?

Any help is greatly appreciated. Thanks in advance!

[v-danhe-msft · Accepted solution]

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]

Hi @v-danhe-msft ,

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

Thanks!

[v-danhe-msft]

Hi @Anonymous ,

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

Regards,

Daniel He