cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Sum of Average

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Sum of Average

Hi @GM17,

 

Please create a measure with below formula:

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

1.PNG

 

Best regards,
Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Resolver III
Resolver III

Re: Sum of Average

@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

Highlighted
Microsoft
Microsoft

Re: Sum of Average

Hi @GM17,

 

Please create a measure with below formula:

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

1.PNG

 

Best regards,
Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: Sum of Average

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,

 

Highlighted
Helper I
Helper I

Re: Sum of Average

Hi

 

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

 

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors