cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SimTechie Frequent Visitor
Frequent Visitor

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:

Indirectly Related.JPGThe 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.

Data Table.JPGThe resulting table visual

How to get the exact Count of PamID by SamName?

Any help is greatly appreciated. Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @SimTechie ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

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

Hi @SimTechie ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SimTechie Frequent Visitor
Frequent Visitor

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

Hi @v-danhe-msft ,

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

Thanks!

Community Support Team
Community Support Team

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

Hi @SimTechie ,

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.