Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Total Average

Hello All,   Below is the sample data. I am trying to calculate average of Days by Section and drill through by Month. I can get the average for a, c, e but not for ab.  ab = a+c+e I want a,c,e ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey Aree,

 

Thanks for the effort but i need average of ab(ab=a+c+e) in the bar chart.

 

 

Thanks

Aree's avatar
Aree
Resolver I
7 years ago

Hey Anonymous 

if you mean the average of each section all added together then within the SectionAverage table just create this measure.

TotalAverage = SUMx(ALL(SectionAverage), SectionAverage[Average])

If this is not what you meant please explain.