samsha786Helper I6 years agoAverage 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)) * ...Show More
amitchandakSuper User6 years agosamsha786 , try something like this Allocation % Average = AVERAGEX(values('Project Resources'[Architecture chapter]), 'Project Resources'[Allocation %])
samsha786Helper I to amitchandak6 years agoHi. Thanks for your answer unfrotunately, that didn't work.amitchandakSuper User to samsha7866 years agosamsha786 ,Can you share sample data and sample output.
samsha786Helper I to amitchandak6 years agoHi. Thanks for your answer unfrotunately, that didn't work.
Related contentMeasure returning incorrect valueMeasure Total IncorrectDAX Measure for Ranking the valid rows and calculating the average ratingRolling 12M Average measureDAX Measure Returning Incorrect Results
