Forum Discussion

Maddy888's avatar
Maddy888
Regular Visitor
1 year ago
Solved

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 Ta...
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    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's avatar
amit_maniyar
Helper I
1 year ago

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