Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Maddy888
Regular Visitor

Row Count in a Table Visual with Two Tables Linked via third table

I have a table visual on the front end that has the fields Table1.Field1 and Table3.Field1. I need the count of rows for this combination.

I am not able to use Countrow Summarize function because Table 2 and Table 3 has many to many relationship.

 

Maddy888_0-1746113469764.png

 

1 ACCEPTED SOLUTION
v-saisrao-msft
Community Support
Community Support

Hi @Maddy888,

Thank you for reaching out to the Microsoft Fabric Forum Community and also thanks for sharing the details and relationship structure it’s helpful context. To better understand the issue and provide a more accurate solution, could you please share a small set of sample data  from each of the three tables Ideally, the sample should include just enough rows to reflect the relationships you're working with (especially where the many-to-many behavior occurs).

If possible, please include:

  • A few rows from each table.

  • The relevant columns (Field1, Field2, etc.) mentioned in your visual.

  • An example of what you're expecting to see in the visual output.

This will help the community replicate your scenario and offer a working DAX solution or model suggestion. Looking forward to helping you resolve it!

 

Thank you.

View solution in original post

6 REPLIES 6
v-saisrao-msft
Community Support
Community Support

Hi @Maddy888,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @Maddy888,

 

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

 

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @Maddy888,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @Maddy888,

Thank you for reaching out to the Microsoft Fabric Forum Community and also thanks for sharing the details and relationship structure it’s helpful context. To better understand the issue and provide a more accurate solution, could you please share a small set of sample data  from each of the three tables Ideally, the sample should include just enough rows to reflect the relationships you're working with (especially where the many-to-many behavior occurs).

If possible, please include:

  • A few rows from each table.

  • The relevant columns (Field1, Field2, etc.) mentioned in your visual.

  • An example of what you're expecting to see in the visual output.

This will help the community replicate your scenario and offer a working DAX solution or model suggestion. Looking forward to helping you resolve it!

 

Thank you.

amit_maniyar
Helper I
Helper I

Hi @Maddy888,
Seems like you are trying to count the records that has a matching relationship with the other table. It is little blurry to understand without sample data.


But I am assuming you are better off with leveraging Merge queries (power query) to count the matches and mismatches. Blank values would indicate that the relationship did not match.

 

That way you count the records without blanks.  Share the sample data (As instructed by @lbendlin )

Thanks,
AM

lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.