Set up KPI's Visuals

[Gilly66]

Good Afternoon 

I am fairly new to Power Bi and although I have created a dashboard using my Contracts data base, I now wish to start looking at things in more detail.  One of those is to look at the KPI Visual and I have a number of parametres which make up my overall healthcheck they are, 

• Meetings 
• Standard financial Instructions 
• Penalty Clauses 
• Copy of Contract 
• KPI's 

Each on is then weighted by 20% to give an overall compliance of 100%.

I am hoping to therefore have 5 cards measuring each one over a period of time but dont know where to start - can anyone help?

Regards

Paul

[Anonymous · Accepted solution]

Hi @Gilly66 ,

I don't know exactly what effect you are trying to achieve, but I can provide you with an example:
I create 5 measures for all KPIs:

KPI 1 = AVERAGE('Table'[Copy of Contract])

KPI 2 = AVERAGE('Table'[KPI's])

KPI 3 = AVERAGE('Table'[Meetings])

KPI 4 = AVERAGE('Table'[Penalty Clauses])

KPI 5 = AVERAGE('Table'[Standard financial Instructions])

And then, I can use this DAX to calculate the total KPI:

Total KPI = 0.2 * ([KPI 1] + [KPI 2] + [KPI 3] + [KPI 4] + [KPI 5])

I hope it will help you!

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.