Forum Discussion
Solved
Calculate average using Switch condition
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
)
May be try this to see if it gives you what you want:
Averagex(Table where Efficicency Rating sits, [Efficiency Rating])
