Forum Discussion

OleMcDonald's avatar
OleMcDonald
Icon for Helper I rankHelper I
5 years ago
Solved

Count records in a joined table

I have two tables [Account] and [Contact] They have a one (account) to many (contact) join  The [Contact] table has a [Job Group] column The [Job Group] is populated with a single value like "CEO"...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi OleMcDonald 

     

    Count of Id for CEO =
COUNTROWS (
    FILTER (
        'Account',
        CALCULATE ( COUNT ( 'Contact'[Job_Group__c] ), 'Contact'[Job_Group__c] = "CEO" ) = 0
    )
)

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi OleMcDonald 

 

Count of Id for CEO =
COUNTROWS (
    FILTER (
        'Account',
        CALCULATE ( COUNT ( 'Contact'[Job_Group__c] ), 'Contact'[Job_Group__c] = "CEO" ) = 0
    )
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers