cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sjpathak Frequent Visitor
Frequent Visitor

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: KPI across multiple tables

Hi @sjpathak

 

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

 

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

Regards,

Cherie

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: KPI across multiple tables

Hi @sjpathak

 

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

 

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

Regards,

Cherie

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.