Custom Table Issue

[TheCreepster1]

Hi there. I've got a particularly stubborn stakeholder who is requesting data be presented in a very specific manner and I'm struggling to think how to do this in Power BI. I've created some custom tables before and used the Switch formula to populate the cells, but I've done that when I have one column on which to base the value, and this new request has two. Essentially, what I am trying to emulate is the below. If you ignore the made up numbers as I know the maths doesn't work, but this should give an idea of the look I am trying to achieve. Any pointers would be much appreciated!

This is a custom table I have succesfully created before, where I base the measure in the cell on the row value, but in the above example I'd need to base it on the Channel and Measure in order to populate the cell.

[jdbuchanan71]

@TheCreepster1 

Take a look at this video that uses nested SWITCH to accomplish what I think it is you are trying to get to.

https://www.youtube.com/watch?v=WV5KxZRIzUE&ab_channel=AviSingh-PowerBIPro