cancel
Showing results for
Did you mean:
Helper I

## % Variance on columns with %of GT format

Hello,

Kindly if someone can help me to figure out a mesure to calculate variance between two columns formated with percentage of total.

My 2 columns E and F are displayed on Powerbi as Percentage of GT

I need to calculate on Power Bi the column G using these percentages of the columns E and F

1 ACCEPTED SOLUTION
Helper I

Finally I was able to solve this, thanks to the solution posted on the following link https://community.powerbi.com/t5/Desktop/What-is-the-GT-Quick-Calculation-really/m-p/177595#M77682

I used measure to calculate %GT for each column

%GT = [Total Items]/CALCULATE([Total Items],ALLSELECTED('Table1'))
%GT LY = [Total Items LY]/CALCULATE([Total Items LY],ALLSELECTED('Table1'))

than another measure to calculate the variance

Var %GT = ([%GT]-[%GT LY])/[%GT LY]

Quite easy 😀
Helper I

Finally I was able to solve this, thanks to the solution posted on the following link https://community.powerbi.com/t5/Desktop/What-is-the-GT-Quick-Calculation-really/m-p/177595#M77682

I used measure to calculate %GT for each column

%GT = [Total Items]/CALCULATE([Total Items],ALLSELECTED('Table1'))
%GT LY = [Total Items LY]/CALCULATE([Total Items LY],ALLSELECTED('Table1'))

than another measure to calculate the variance

Var %GT = ([%GT]-[%GT LY])/[%GT LY]

Quite easy 😀

Announcements