Forum Discussion
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.
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.
-
6 Replies
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi 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,
AMHi 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.
-
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.
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.
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.
