Forum Discussion
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...
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
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
That did it, many thanks.