Forum Discussion

MTOnet's avatar
MTOnet
Icon for Helper III rankHelper III
5 years ago
Solved

Count Linked Records When an Intermediary Table Creates the Relationship Between Two Tables

I have data in 3 tables.  I am trying to count how many records are in the third table, which are related to items in the first table.  There is an intermediary table between the two that establishes...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  MTOnet ,

    Here are the steps you can follow：

    1. Connect the relationship between the three tables

    2. Create measure

    count =
CALCULATE(COUNT(TableC[RecordC]),FILTER(ALL(TableA),[LinkedRecordB]<>BLANK()))

    3. Result.

    You can downloaded PBIX file from here.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi MTOnet 

 

What is the expected result? Is Record A distinct in Table A, and Record B distinct in Table B? And you want a DAX calculated column in Table C?