Forum Discussion
Solved
Variance % Not Showing Correctly
Hi all, I have the data shown below: I've input this data into Power BI and created a Matrix as shown below. Department and Month values are used as drop down filters. Unf...
add new measure for variance %
% Variance = var variance = SUM(Table[Plan]) - SUM(Table[Actuals]) return DIVIDE(variance, SUM(Table[Plan]), 0)
in data modelling tab change % Variance type to percentage.
I prefer different measure for each calculation thou like this
Total Actual = SUM(Table[Actual]) Total Plan = SUM(Table[Plan]) Total Variance = [Total Plan] - [Total Actual] % Variance = DIVIDE([Total Variance], [Total Plan], 0)
add new measure for variance %
% Variance = var variance = SUM(Table[Plan]) - SUM(Table[Actuals]) return DIVIDE(variance, SUM(Table[Plan]), 0)
in data modelling tab change % Variance type to percentage.
I prefer different measure for each calculation thou like this
Total Actual = SUM(Table[Actual]) Total Plan = SUM(Table[Plan]) Total Variance = [Total Plan] - [Total Actual] % Variance = DIVIDE([Total Variance], [Total Plan], 0)
