Help to get a measurement as a constant

[Syndicate_Admin]

Hello I have a table with customer sales lines, and each row is assigned to an agent (numerico). I need to take out a measure that is fixed, that is the average of the sum of the number of (distinct) clients of the agents that I specify.

Example: I want the average number of clients of agent 23, 24 and 25

agent 23 has (distinct) clients = 50

agent 24 has (distinct) clients = 70

agent 25 has (distinct) clients = 60

media = 180/3 = 60

and q that average does not vary as long as I do not change the codes of the agents by code, or add/ remove agents.

I'm trying with averagex but I can't get it.

Thank you.

[amitchandak]

@Syndicate_Admin ,

AverageX(values(Table[agent]), Calculate(distinctcount(Table[clinet] ) ) )

[Syndicate_Admin]

Hello, so I get the average of customers of all agents, but I need to specify the agents I want

[v-yiruan-msft · Accepted solution]

Hi @ivanmoreno ,

I created a sample pbix file(see attachment), please check whether that is what you want. I created two measures as below, please check which one is your expected result. 

average of agents = 
VAR _tab =
    SUMMARIZE (
        'Table',
        'Table'[agent],
        "@coutofclients", CALCULATE ( DISTINCTCOUNT ( 'Table'[client] ) )
    )
RETURN
    AVERAGEX ( _tab, [@coutofclients] )

avarage 2 = 
VAR _sumofclients =
    CALCULATE ( DISTINCTCOUNT ( 'Table'[client] ), ALL ( 'Table' ) )
VAR _countofagent =
    CALCULATE ( DISTINCTCOUNT ( 'Table'[agent] ), ALL ( 'Table' ) )
RETURN
    DIVIDE ( _sumofclients, _countofagent )

Best Regards