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 a...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi sjpathak

     

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

     

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

    Regards,

    Cherie

     

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi sjpathak

 

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

 

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

Regards,

Cherie