Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 'MAT Dispensed Amount CY'. MAT is moving annual total, CY is current year and LY is last year. I also have another column which is '% Growth MAT Amount CY' which is growth in the MAT over the last year. The measures are calculated as follows:
For example, the EI for the product Calcigard should be (20.52/31.66)*100 = 64.81. The EI for the market is always 100 i.e. (31.66/31.66)*100. A product having an EI above 100 means it is growing above the overal market and conversely.
My calculaton for the EI which i have tried is as follows:
Solved! Go to Solution.
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.
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.
Thank you very much for the assistance, most appreciated.
Best regards,
Chris
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |