Getting sn asverage of more than one measure

[corrynduta]

I am creating something like a score card.

I handle a reion with 12 countries. I have five Operations KPIs that that cuts across all countrys. and are presented as percentages. In my report, I have created this KPIs as separate measures (%)e.g purchasing efficiency supply hain efficiency etc.

Now I want to rank the 12 countrys as per the score attained by averaging all the KPI Scores. i.e say Country no 1 Has the highest score in most KPIs etc.

How do I create the measure?

My thoughts were to create a measure that can average my five KPIs measures before ranking per location, However, I can figure out what aggregate to use, I have tried Averagex but it only takes one measure thus cannot average all my five measures.

Will appreciate any help.

[jdbuchanan71 · Accepted solution]

Hello @corrynduta 

You should be able to do something like 

KPI Average =
AVERAGEX (
    VALUES ( Countries[Country] ),
    ( [KPI 1] + [KPI 2] + [KPI 3] + [KPI 4] + [KPI 5] ) / 5
)

[corrynduta]

Thank you 🙂
It worked!