Average times different clients appear

[SHILL]

How can I count the average time a client will appear in a list.
For example, in the below list, the average number of times a client appears is 2 (Client 1 appears twice, Client 2 Once & Client 3 three times)

Client 1
Client 2
Client 3
Client 1
Client3
Client 3

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new measure.

Average times a client appears measure: =
AVERAGEX (
    ADDCOLUMNS (
        VALUES ( Data[Client] ),
        "@count", CALCULATE ( COUNTROWS ( Data ) )
    ),
    [@count]
)