Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
corrynduta
Frequent Visitor

Getting sn asverage of more than one measure

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.

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

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
)

KPIAverage.jpg

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

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
)

KPIAverage.jpg

Thank you 🙂
It worked!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.