Forum Discussion
KPI Scorecard - Rank
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"))))))))
2 Replies
Anonymous Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
