KPI Scorecard - Rank

[Anonymous]

Im trying to replicate this table in PBI. What I need is a way to calculate the number of Points based on the weight for the end of month results.  I've been trying a lot of different measures but I can't get it right

Points = IFERROR(IF(N9 < 0, 0, N9*E9),E9)

%of Goal = IFERROR(IF(GETPIVOTDATA(Data) <=0,"N/A",GETPIVOTDATA("Data")),"--")

Grade =IF(N9="","",IF(N9>=1,"A+",IF(N9>=0.95,"A",IF(N9>=0.9,"B+",IF(N9>=0.85,"B",IF(N9>=0.8,"C+",IF(N9>=0.75,"C",IF(N9>=0.7,"D+","D"))))))))

[amitchandak]

@Anonymous Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Data sample here. https://drive.google.com/file/d/1zzo6CTCYy1w5yNOMFp8JhXkqxQ7k_vWK/view?usp=sharing