cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Average of Measure Incorrect

Created this view:

Average.png

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?
4 REPLIES 4
Community Support
Community Support

Hi  @samsha786 ,

 

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

Annotation 2020-05-15 153105.png

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!

 

Super User IV
Super User IV

@samsha786 , try something like this

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors