Forum Discussion
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.
Unfortuntly, Power BI aggereages and sums all the Variance %s as shown in the last column. Is there a way to have the Variance % column calculted in an Ad Hoc based manner based on whatever is selected.
The formula i have for the Variance % column is: Variance % = IFERROR(Combined[Variance $]/Combined[Plan],0)
Thank you,
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)
2 Replies
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)
