Converting a rank/count/value apportionment formula from Excel to BI

I have a formula in Excel which takes a total cost value and apportions it against various grades, which are ranked.  The quantity of a particular ranking can vary by month and by factor (shown here ...