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:
"CountMes",DISTINCTCOUNT('Date'[Year Month Number]),
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