Forum Discussion

sjpathak's avatar
sjpathak
Frequent Visitor
7 years ago
Solved

KPI across multiple tables

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?

 

  • Hi sjpathak

     

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

     

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

    Regards,

    Cherie

     

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee

    Hi sjpathak

     

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

     

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

    Regards,

    Cherie