Build the Average of a Division

[tuncay]

I've a Division column, which differs all existing Factories from each other. For example, there is a Division U and underneath there are Factories. The Factories can be with the column "Organizational Unit". I was able to create and add "Div. U" as an additional Organizational Unit, in oder to get the Average of that Division. However, I am not able to do. With that written formula, it only calculates the Average of the Factories, that I filter...

ValueKPI = 
var getOrgUnit = SELECTEDVALUE('Organizational Unit'[Organizational Unit])
var AvgDiv = CALCULATE(AVERAGE('KPI data'[Value]), FILTER(ALLSELECTED('Organizational Unit'), 'Organizational Unit'[Division] = "U"))
Return
SWITCH(TRUE(), getOrgUnit = "Div. U", AvgDiv, SUM('KPI data'[Value]))

As you can see I get the "Div. U" which is the Average of that Factories, which is 2,03. But when I deselect a Factory or select only 2 the Average changes.. I want to have it static so it does only show the average of the WHOLE Factories, which belong to Division U... 

[amitchandak · Accepted solution]

@tuncay , based on what I got, Please replace all with allselected

ValueKPI =
var getOrgUnit = SELECTEDVALUE('Organizational Unit'[Organizational Unit])
var AvgDiv = CALCULATE(AVERAGE('KPI data'[Value]), FILTER(ALL('Organizational Unit'), 'Organizational Unit'[Division] = "U"))
Return
SWITCH(TRUE(), getOrgUnit = "Div. U", AvgDiv, SUM('KPI data'[Value]))