Calculate average using Switch condition

[krishanw]

I need to calculate the average of the Efficiency Rating, But when I try to calculate the average of the efficiency rating, value is not loading 

This is my switch Condition

Efficency Rating =

SWITCH(TRUE(),

--P1

'Efficiency Matrix'[EfficencyRate]>=0 && 'Efficiency Matrix'[EfficencyRate]<=25,50,

'Efficiency Matrix'[EfficencyRate]>=24 && 'Efficiency Matrix'[EfficencyRate]<=50,75,

'Efficiency Matrix'[EfficencyRate]>=51 && 'Efficiency Matrix'[EfficencyRate]<=99,90,

'Efficiency Matrix'[EfficencyRate]>=100,100,

'Efficiency Matrix'[EfficencyRate]>0 && 'Efficiency Matrix'[EfficencyRate]<=-25,-50,

'Efficiency Matrix'[EfficencyRate]>-24 && 'Efficiency Matrix'[EfficencyRate]<=-50,-75,

'Efficiency Matrix'[EfficencyRate]>-51 && 'Efficiency Matrix'[EfficencyRate]<=-99,-90,

'Efficiency Matrix'[EfficencyRate]<=-100,-100

)

[olgad · Accepted solution]

May be try this to see if it gives you what you want:

Averagex(Table where Efficicency Rating sits, [Efficiency Rating])

[krishanw]

Hi I was able to find this solution thanks