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 SageFollow:
1-Creating a measure:
SUMMeasure=SUM('Table'[PowerData])
2-Then the measure below is what you want:
AVGMeasure=AVERAGEX(
VALUES(Table[Date]),
[SUMMeasure]
)
emmawdmi22Helper I
Helper IThank you!