I have finished reviewing your solution, it will work fine. Now that I can calculate and apply the allocation, I’d like to merge the “Modified Cost” and “Total Revenue” measure into a single measure, in order to present a gross margin (or P&L view, by category) layout. Of course that requires negating the sign for Value where the Attribute = Cost, which I have done in revising your attached Pbix file (as a new measure).
However, now I have the challenge of calculating this supplemental measure, so that I can achieve this view. Below shows how the view would look vertically, but of course I have not figured out how to present true Revenue (grossed up = $1,525) and Cost (after the allocation = ($2,850).
eDNA - handling specific field value calc - round 2b (modify value sign for Cost).pbix (27.1 KB)