You're not going to be able to use MeasureName/MeasureValue like you have on sheet 1. Tableau will handle the formatting of the text uniformly across all the measures.
On Sheet 2 I changed the display (only two of the measures for now) to a technique that lets you format each measure column separately. (Note: This involves some tedious work to get things just right.)
I put a bogus measure on the columns shelf for each measure you want to display. Here I used SUM(0). Then for each mark I put the actual measure on the TEXT shelf (such as sum of profits.) This creates an axis at the bottom of each, with 0 as the axis label and a 0 axis tick. For the Profits column I edited the axis label to say Profits, and I set ticks to NONE. You'll do this for all your measures.
On Sheet 3 I changed things further. I changed the bogus measure to be a constant, and I changed the mark type from square to bar. This allows for narrower rows, and because there is a constant value (AVG(something)) rather than a SUM of 0, I get a full, wide background color.
Next I started messing with the colors for the text. Look at what is in the text shelf for the AVG(2) mark. I have two calcs. One I can set to red, and the other to black. The logic in the calcs is such that I will either have one or the other set, and whichever is set with a value, the other will contain null. I placed them side-by-side in the label editor, and colored one red and the other black. For kicks I also changed the font size of red. You can see the results. Only one will display in each row because the other will be null. (If I had put a calc on the color shelf, it would have controlled the color of the bar, not the color of the text.
I didn't do any formatting of AVG(10). I think you just needed to see how to make it work, and now you can apply this to your actual application.
I'll stop here for now. I could discuss a whole bunch of other formatting details you can play with, (and some limitations this technique has), but you may or may not need them. So if you want to change something and can't figure out how to get to it, just ask.
Yes, I can get the labels to the top, but it's another tedious layer, and I can't get to that now.
I'll show you later this weekend.
In the attached I made a copy of the last sheet.
To get labels at the top, make a dual axis with yet another bogus measure. When you do that, you get a label at both the top and the bottom. Clear out the axis label off the bottom and set the top one to Profits. You'll have to format the new bogus measure to get the zero-line out of there, and color the zero bars the same color as the original profits bars.
So yes, if you are doing a dozen measures like this, you'll have a dozen dual axis pairs.