Forum Discussion

Chitemerere's avatar
Chitemerere
Responsive Resident
6 years ago
Solved

Relative Growth Rate (Evolution Index) Calculation

I am trying to calculate a relative growth rate or so called evolution index as per the following:   I have columns which are calculated measures.  These are 'MAT Dispensed Amount LY' and 'MA...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Chitemerere ,

     

    we can create a measure to get the EI CY Amount to meet your requirement.,

     

    EI CY Amount = DIVIDE([% Growth MAT Amount CY],CALCULATE([% Growth MAT Amount CY],ALLSELECTED())) *100

     

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

     

    BTW, pbix as attached.

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Chitemerere ,

 

we can create a measure to get the EI CY Amount to meet your requirement.,

 

EI CY Amount = DIVIDE([% Growth MAT Amount CY],CALCULATE([% Growth MAT Amount CY],ALLSELECTED())) *100

 

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

 

BTW, pbix as attached.

 

  • Chitemerere's avatar
    Chitemerere
    Responsive Resident
    6 years ago

    Thank you very much for the assistance, most appreciated.

     

    Best regards,

    Chris