How to calculate average of client approaches?

[MadalenaBicho]

Good afternoon everyone,

I want to calculate the average number of times a client approaches us but can't seem to be able to figure out a measure or another way to do it so any advice would be appreciated. 

My data looks like this:

Row 1 - Client 1 - 01/01/2025

Row 2 - Client 2 - 01/01/2025

Row 3 - Client 2 - 02/01/2025

Row 4 - Client 3 - 02/01/2025

Row 5 - Client 1 - 03/01/2025

So, as you can see, sometimes the same client will approach us multiple times, but on different dates. What I would like to see is the average of approaches, that is, how many times the average client approaches us. So, in the example above, this would be 1.66.

However, I can't seem to figure how to do this on Power BI in order to display it on a card visual. 

Thank you in advance! 

[PijushRoy · Accepted solution]

Hi @MadalenaBicho 
Please find the measure 

Measure = VAR _TotalApproaches = COUNT('Table'[Approach])
VAR _DistinctClients = DISTINCTCOUNT('Table'[Client])
RETURN
_TotalApproaches / _DistinctClients