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

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.