Calculate Occurence

[qwertzuiop]

Hello dear PowerBI-Community

Hope you all doing well so far.

I habe the following problem.

I would like to count how many times a specific forename in combination with it's lastname occurs.

Take this table as example (Red column is what I want to calculate)

Any Ideas?

forename	surename	Occurence
Max	Miller	2
Max	Watson	2
Alice	Shiffrin	1
Max	Watson	2
Max	Miller	2
Alice	Muster	1
Ann	Bond	1

Thank you very much for your contribution.

Cheers

qwertzuiop

[az38]

Hi @qwertzuiop 

try

Occurence = CALCULATE(
COUNTROWS('Table'), 
ALLEXCEPT('Table', 'Table'[forename], 'Table'[surename])
)

[qwertzuiop]

Hi @az38 

Thank you so much for your help.

But unfotunatelly I can't test this formula in my example because the formula may not fit.

Could you attach a testfile where you use this formula?

Cheers

[az38 · Accepted solution]

@qwertzuiop 

https://ufile.io/4ohv9nhd

[qwertzuiop]

Hi @az38 

Thank you so much for your quick respone and your solution.

It works as expected.

Cheers.