Help With Replicating Excel KPI Function in PowerBi

Hi,

I have an existing Excel function that I would like to replicate in PowerBi. The function calculates the RAG status of multiple metrics/kpi's based on parameters (essentially weightings) to return the RAG color based on those parameters.

I've replicated the metrics and RAG colors for each metric in PowerBi but I need help on how to calculate the RAG Status that was used in Excel. 

I hope that makes sense. Attached screenshots and files for reference.

Appreciate any help tamerj1  SpartaBI johnt75 Jihwan_Kim 

Excel version:

https://docs.google.com/spreadsheets/d/1kF5ABNd3WWAPfLdlmvsvaVhbYQQ7jacd/edit?usp=sharing&ouid=106267973063939566544&rtpof=true&sd=true

Pbix version:

https://drive.google.com/file/d/1EophB1pcV93xEqlckI9UVAluwl4_ok6R/view?usp=sharing