Sum of Average

[GM17]

Hi All,

I have a column in a table with below expression

AVERAGEX(VALUES('VW_PRS_LifeCycleState2'[LifeCycleState]),CALCULATE(AVERAGE(VW_PRS_LifeCycleState2[Target_Round2])))

I need to have the total displayed with SUM of "Average" of all the detail rows. The above expression is working fine for Average in detail rows while total is not correct. Currently total as well is doing the average while i need the SUM of averages.

Please suggest?

Thanks

Gaurav

[v-yulgu-msft · Accepted solution]

Hi @GM17,

Please create a measure with below formula:

Average =
SUMX (
    VALUES ( 'VW_PRS_LifeCycleState2'[LifeCycleState] ),
    AVERAGE ( VW_PRS_LifeCycleState2[Target_Round2] )
)

Best regards,
Yuliana Gu

[Lexey]

Hi

strange, but for some reason it works here is such a formula

Measure = AVERAGEX(VALUES('table'[name]);SUM('table'[values]))

[dk_24]

Hi Yuliana Gu,

i am also looking for the similar type of solution , i have tried but no luck .can you please have a look on it.

https://community.powerbi.com/t5/Desktop/Sum-of-Average/m-p/288894#M127118

thanks,

[chethan]

@GM17 go to the data 

Create the New Column & Enter the Function 

SumofAverage =AVERAGEX(VALUES('VW_PRS_LifeCycleState2'[LifeCycleState]),CALCULATE(AVERAGE(VW_PRS_LifeCycleState2[Target_Round2])))

Create New Column 

Column =  [SumofAverage ]

if you find any difficulty share the sample data

Regards,

Chetan K