Forum Discussion
emmawdmi22
Helper I
Helper IAverage of Sum Measure
I need an average of the max of sums.
Follow:
1-Creating a measure:
SUMMeasure=SUM('Table'[PowerData])2-Then the measure below is what you want:
AVGMeasure=AVERAGEX( VALUES(Table[Date]), [SUMMeasure] )
MohammadLoran25
Solution Sage
Solution SagePlease share an example with data that you want to be shown as your result.
emmawdmi22Helper I
Helper ISo if this is the data I am given, the answer would be 90. Sum up by the similar time first, then take an average of those sums. So ((10+20+30)+(40+60+80)+(10+20))/3
- MohammadLoran25
Follow:
1-Creating a measure:
SUMMeasure=SUM('Table'[PowerData])2-Then the measure below is what you want:
AVGMeasure=AVERAGEX( VALUES(Table[Date]), [SUMMeasure] )- emmawdmi22
Thank you!