Forum Discussion
Need help in the pricing calculation.
I made a sample dataset using the table you provided, I believe the below measure is behaving as you would want it to:
Raw measure code:
GMV Calc =VAR _GMV = 400000 /*Replace with your actual gmv column/measure*/VAR _table = FILTER('Main Data Table', _GMV > 'Main Data Table'[Volume Minimum])RETURNSUMX(_table, (IF(_GMV > [Volume Maximum], [Volume Maximum], _GMV) - (IF([Volume Minimum] = 0, [Volume Minimum], [Volume Minimum] - 1))) * [BPS])
Hi Anonymous, I apologize for the oversight. There have been slight adjustment in the calculation
please find the updated calculation
Example: Customer GMV: $400,000
This GMV values lies in 'Row 3'.
Calculations for 'Row 1, 2 and 3':
Considering Max Volume if Amount is beyond that.
Amount 1 = 24999 * (BPS) 0.005 = 124.995
Amount 2 = (249999 - 24999) * (BPS) 0.005 = 1125
Amount 3 = (400000 - 249999) * 0.005 = 750.005
Final Amount = Amount 1 + Amount 2 + Amount 3
Final Amount = 124.995 + 1125 + 750.005 = 2000
Customer GMV is used in Amount 3 calculation
I made a sample dataset using the table you provided, I believe the below measure is behaving as you would want it to:
Raw measure code:
Hi Anonymous, Thanks for your help.
The solution is working perfectly for me.