Calcultate Average of Code

[rbustamante]

I have a table with incident tickets, with one unique code, and the date of the incident of the last 5 years.

I need to define a new measure with the average of number of tickets by year.

Inside the measure I'm able to make the following table:

with this code:

var _kk=SUMMARIZE(

NCs,

'Date'[Year],

"CountMes",DISTINCTCOUNT('Date'[Year Month Number]),

"CountCode",COUNT(NCs[CODE])

)

After do this, I don't know how to calculate the average by year that is the result of divide CountCode/CountMes.

Thanks for your help

[amitchandak · Accepted solution]

@rbustamante , Try like

AvergaeX(SUMMARIZE(
NCs,
'Date'[Year],
"CountMes",DISTINCTCOUNT('Date'[Year Month Number]),
"CountCode",COUNT(NCs[CODE])
), divide([CountCode],[CountMes]))

or

AvergaeX(SUMMARIZE(
NCs,
'Date'[Year],
"CountCode",COUNT(NCs[CODE])
), [CountCode])