Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Hi @sjpathak
You may new a column for KPITargets table with below dax:
Column = IF ( KPITargets[ID] = "Punctuality", [Measure1.DeliveryPunctuality], [Measure2.StockAvailability] )
Regards,
Cherie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |