Forum Discussion

marmaghan's avatar
marmaghan
Frequent Visitor
7 years ago
Solved

Conditional Division

Hi, I am stuck in a situation please guide me  in below mention data which Have ID targets and achievement of KPI's I have create a pivot table as mention below and have created three measures   =...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi marmaghan,

     

    Based on your data you shared, we can create a measure to achieve your goal.

     

    Measure = IF(MAX(Table1[KPI])="E"&& [Ach%]>=105,105,IF([Ach%]>=120 && MAX(Table1[KPI])<>"E",120,[Ach%]))

    Also please find the pbix as attached.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi marmaghan,

 

Based on your data you shared, we can create a measure to achieve your goal.

 

Measure = IF(MAX(Table1[KPI])="E"&& [Ach%]>=105,105,IF([Ach%]>=120 && MAX(Table1[KPI])<>"E",120,[Ach%]))

Also please find the pbix as attached.

 

Regards,

Frank

  • marmaghan's avatar
    marmaghan
    Frequent Visitor
    7 years ago

    Thanks for reply it is working fine now