Forum Discussion

shill1000's avatar
shill1000
Icon for Helper IV rankHelper IV
9 years ago
Solved

KPI with row level targets

I'm trying to get my head around something and I'm not sure I'm taking the right approach. I have a table of contract names, an achievement value for each contract and a target for each specific cont...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi shill1000,

     

    In that case, you just need to make a little adjustment to above measures:

    Measure target = CALCULATE(SUM('KPI'[Target Value]),ALLSELECTED('KPI'))

Measure Performance = CALCULATE(SUM('KPI'[SLA Performance]),ALLSELECTED('KPI'))

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi shill1000,

 

You can create two measures and add measures into KPI target area and indicator area, instead of directly adding [SLA Performance] and [Target value] fields.

Measure target = CALCULATE(SUM('KPI'[Target Value]),ALL('KPI'))
Measure Performance = CALCULATE(SUM('KPI'[SLA Performance]),ALL('KPI'))

 

Best regards,
Yuliana Gu

  • shill1000's avatar
    shill1000
    Icon for Helper IV rankHelper IV
    9 years ago

    Thanks for that, I hadn;t thought of a measure for both values. However, it fixes one problem and creates another. When I apply a contract filter via the table, a slicer or a page level filter, the KPI isn;t changing to reflect the filter. I was trying to get the KPI to show an overall figure when no selection is made and tehna combined figure if specific contracts are selected?

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi shill1000,

       

      In that case, you just need to make a little adjustment to above measures:

      Measure target = CALCULATE(SUM('KPI'[Target Value]),ALLSELECTED('KPI'))

Measure Performance = CALCULATE(SUM('KPI'[SLA Performance]),ALLSELECTED('KPI'))

       

      Best regards,
      Yuliana Gu

      • shill1000's avatar
        shill1000
        Icon for Helper IV rankHelper IV
        9 years ago

        That did it, many thanks.