Forum Discussion

samsha786's avatar
samsha786
Icon for Helper I rankHelper I
6 years ago

Average of Measure Incorrect

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)) * ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

samsha786 , try something like this

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

  • samsha786's avatar
    samsha786
    Icon for Helper I rankHelper I
    6 years ago

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

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      samsha786 ,Can you share sample data and sample output.