Forum Discussion
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...
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.