Average of Sum Measure

[emmawdmi22]

I need an average of the max of sums.

[grantsamborn]

Hi @emmawdmi22 

How about this?

zMeasure = 
    CALCULATE(
        AVERAGE( 'DataTable'[PowerData] ),
        ALLEXCEPT( 'DataTable', 'DataTable'[TimeStamp]
        )
    )

[MohammadLoran25]

Hi @emmawdmi22 ,

I am not sure If I understand what you need exactly.

But I think:

1-Creating a Measure:

SUMMeasure=SUM('Table'[PowerData])

2-Creating another measure:

AVGMeasure=AVERAGEX(
SUMMARIZE('TABLE','TABLE'[PowerData],'TABLE'[MachineId])
,
[SUMMeasure]
)

If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran

[emmawdmi22]

Thank you for your reply. This is almost right but not quite, I still need to group the original sum by the date/minute value before averaging it. How would I do this? 

[MohammadLoran25]

Please share an example with data that you want to be shown as your result.

[emmawdmi22]

So 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 · Accepted solution]

@emmawdmi22 

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!