Average of Measure Incorrect

[samsha786]

Created this view:

Here's the measure for this: 

Allocation % = SUMX('Project Resources', ((DATEDIFF('Project Resources'[Assigned Start Date], 'Project Resources'[Assigned End Date], DAY)) * 'Project Resources'[Assigned Capacity]) / 365.0)

Works great! The problem comes in when I try to get the average value of this:

Allocation % Average = AVERAGEX('Project Resources', 'Project Resources'[Allocation %])

Please help! What am I doing wrong?

[v-kelly-msft]

Hi  @samsha786 ,

As tested here,it seems that there's no problem in your measure,as you see below:

So what kind of problem are you getting?Can you share part of your data and expected output to make the requirement more clear?

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@samsha786 , try something like this

Allocation % Average = AVERAGEX(values('Project Resources'[Architecture chapter]), 'Project Resources'[Allocation %])

[samsha786]

Hi. Thanks for your answer unfrotunately, that didn't work.

[amitchandak]

@samsha786 ,Can you share sample data and sample output.