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

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.