Variance % Not Showing Correctly

[rohampourmehr]

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,

[parry2k · Accepted solution]

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)

[rohampourmehr]

@parry2k

You sir are a true life saver. Thank you for all your help.

Roham