Selecting Column based on Slicer Selections

I helped someone with this very issue just yesterday. Check out their post: https://community.fabric.microsoft.com/t5/Desktop/Need-help-to-calculate-the-sum-from-different-columns-depending/m-p/3420779#M1135758