average instead of total

[Giada90]

Hi,

I have a sample table like this:

date	code
01/01/2023	a
01/01/2023	b
01/01/2023	c
01/02/2023	d
01/02/2023	e
01/03/2023	f
01/03/2023	g
01/03/2023	h
01/03/2023	i

I do this table with count of code

What I need is a kpi that gives me the average of the count( in this case 3)

How can I do?

Thanks

[johnt75]

try

Count of code =
AVERAGEX (
    SUMMARIZE ( 'Table', 'Date'[Year], 'Table'[mese] ),
    DISTINCTCOUNT ( 'Table'[Code] )
)

[Arul · Accepted solution]

@Giada90 ,

try this,

Average = 
VAR _codeCount = COUNT(
    'Table'[code])
VAR _name = DISTINCTCOUNT('Table'[Name])
VAR _result = DIVIDE(_codeCount,_name)
RETURN _result

Thanks,

Arul

[Giada90]

thanks!