Forum Discussion

tborg's avatar
tborg
Helper I
8 years ago

Calculating variance from an average

Hi all!  I have the following table visualization: What I want to do is to create a column that calculates the variance of Ave. Earnings in each row compared to the variance of the total amoun...
Need Help
bhanson5587's avatar
bhanson5587
New Member
8 years ago

Try something like:


Answer = 
VAR sumAveEarnings = CALCULATE(SUM([Ave. Earnings]),ALL(TABLE1[Category]))
RETURN
(AveEarnings/sumAveEarnings)-1

 

I believe this should work but haven't actually tested it in PBI. Let me know if you have any issues.

tborg's avatar
tborg
Helper I
8 years ago

Thanks, but this is not working.  Please see post below.  Ave. Earnings is a measure, and the SUM function requires a column reference, so I am still stuck.