Dynamic Target setting in Gauges

[ogster1974]

I want to set dynamic targets to a gauge chart.

I have the target data stored in a table for multiple KPIs

LOAD

          Program Id,

          KPI,

          YYYYMM,

          Target

In my expression I want to retrieve a Target for a specific KPI.  e.g.

IF(KPI='MeasureA', SUM(Target),0)  If I add KPI as a filter and select MeasureA it returns the value I'm looking for. 

I want to hard code the selection of the measure in this case and store as a master item for use in other charts and display multiple KPIs on the same page.

[ogster1974 · Accepted solution]

Sorted it out myself with a conditional sum

SUM({$<KPI={'MeasureA'}>} Target)