Simple 'IF' measure in Power Pivot (Error)

[powerwill]

Measure 1 SH-MET% = SUMX(VALUES(Table_Name[Agent_name]), IF([FINAL SCORE]>=0.95 && VALUES(Table_Name[Team])="Sales",1,0))

However, when I pull it in the Pivot, it shows the below Error. Any help is appreciated.

 

[Matt Allington]

I think you can just swap SUMX with AVERAGEX

 

[powerwill]

I think you can just swap SUMX with AVERAGEX

Yes, I did that, it's perfect now. Thank you very much @Matt Allington.