Forum Discussion

Gilly66's avatar
Gilly66
Frequent Visitor
2 years ago
Solved

Set up KPI's Visuals

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.