cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrainey Member
Member

How To Get *Actual* Average

I have this table:

1.PNG 

 

So on the far right column, I'm trying to get the average deal size based on the sum column. By default, PBI is taking $312,994.57 and dividing it by 423 (the number of times a person is in the table) which comes out to $739.94.

 

However, if I export this to an excel file and highlight the far right column from top to bottom, I get $1,158.40 as the average which would be the correct average. How can I get PBI to calculate it that way rather than just doing $312,994.57/423?

1 ACCEPTED SOLUTION

Accepted Solutions
Nick_M Senior Member
Senior Member

Re: How To Get *Actual* Average

Can you try this? I think it shoud work

AVERAGEX(
    Values( Table[Producer]),  //be sure to change to the appropriate table [column] 
    [ Your Sum Measure Here]
 )
1 REPLY 1
Nick_M Senior Member
Senior Member

Re: How To Get *Actual* Average

Can you try this? I think it shoud work

AVERAGEX(
    Values( Table[Producer]),  //be sure to change to the appropriate table [column] 
    [ Your Sum Measure Here]
 )