Forum Discussion

tborg's avatar
tborg
Icon for Helper I rankHelper 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
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi tborg

 

Give this MEASURE a shot

 

Variance =
VAR Total =
    SUMX ( ALLSELECTED ( TableName[Category] ), [Ave,Earnings] )
RETURN
    DIVIDE ( [Ave.Earnings], Total ) - 1
tborg's avatar
tborg
Icon for Helper I rankHelper I
8 years ago

No, that did not work.  It gave me a column for Variance that was mostly -71% to -90%.  I will play with the formula and see if it's just a matter of finding the right columns/measures to use.