Forum Discussion
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-msftMicrosoft 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