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,

 

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.