Getting Avg (Distinct Count) YoY

[YG]

Hi All,

I am trying to get a Average Yoy of count. So far I have tried by 

Avg(Aggr(Count(distinct Incident_Number),[Opened.autoCalendar.Year])) // Wrong average

Below are the table columns and output

Output

I want to get is YoY average of every year put in to Gauge chart. Any help would be appreciated. Thanks 

[tresesco]

Could you share the output you are getting and the one you are expecting?

[YG]

Hi There,

I am trying to achieve is the monthly average line. I have a screenshot from Power Bi which I am trying to replicate. 

Orange color line is the target

For the below chart

But i found it hard so I just want the value count(incident)/(count)months on a Gauge chart. Hope this helps