Average a Measure

Hi Anonymous 

ifyour dat field is a measure, it looks like you should use AVERAGEX() function https://docs.microsoft.com/en-us/dax/averagex-function-dax 

like

Average Days = CALCULATE(AVERAGEX(Table,[Days]), ALLEXCEPT(Table, Table[Department]) )

do not hesitate to give a kudo to useful posts and mark solutions as solution

Sorry I am a bit confused with the"Table" in the measure - could you please explain what it means?

Average Days = CALCULATE(AVERAGEX(Table,[Days]), ALLEXCEPT(Table, Table[Department]) )

Anonymous 

it is the data source name which contains measure {Data] and field column [Department]

do not hesitate to give a kudo to useful posts and mark solutions as solution

Anonymous 

Assuming the following:

- The column "Department" is in a table named Data Table (substitute for your table name obviously)

- Days is a measure: in my case I've called it [Days Measure]

Use this measure to calculate the average days:

Average Days by Department = AVERAGEX('Data Table'; [Days Measure])

And this measure to calculate % over year:

% Average Days / 365 = DIVIDE([Average Days by Department]; 365)

Now set up a table/matrix using the Department column to get you this:

 Hope this helps!