KPI across multiple tables

[sjpathak]

Hi,

I have a 'KPITargets' table as below

ID                    Target

-----------------------

Punctuality       99.0%

Availability        98.5%

There are other tables, from where the actual KPI value is coming from

1. DeliveryPunctuality - It has a measure for the Punctuality KPI above - say current value is 98.9%

2. StockAvailability - It has a measure for the Availability KPI above - say current value is 99.5%

Question is - How do I link the two measures in the above tables to the KPITargets table, preferably, as a custom column, so that I get a KPITargets table as below

ID                    Target          Value

-------------------------------------

Punctuality       99.0%          98.9%

Availability        98.5%         99.5%

I need the above as I want to show the KPI table with its current values as a Clustered Column Chart, showing the individual KPIs, their current target and values.

Any hints?

[v-cherch-msft · Accepted solution]

Hi @sjpathak

You may new a column for KPITargets table with below dax:

Column =
IF ( KPITargets[ID] = "Punctuality", [Measure1.DeliveryPunctuality], [Measure2.StockAvailability] )

Regards,

Cherie