How to count re-occurrences related to a value in another row

[juliamacg_]

Hello! Sorry if the title isn't clear enough, I wasn't sure how to describe it.

The thing is: I'm looking for a way to count the re-occurrences of a given word related to another data on another row. Here's an example on Excel:

The DAX formula I'd like to have would return the value 3, as there is 1 reoccurrence for "Julia" in Code 001, 1 reoccurrence for "Igor" in Code 002, and 1 reoccurrence for "Julia" in Code 003.

I'm cracking my head on this one. Could anyone help me out? Thanks!

[mangaus1111 · Accepted solution]

Hi @juliamacg_ ,

try this measure

Measure = 
VAR _CountRows =COUNTROWS('Facts26')
RETURN
_CountRows - COUNTX(
                    SUMMARIZE('Facts26',
                              'Facts26'[Code],
                            'Facts26'[Analyst]
                             ),
                       _CountRows
                )

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

[juliamacg_]

Worked like a charm! Thanks so much, friend! Have a blessed day!