Dynamic Column based on aggregated measure

Hello all,   I am trying to create a dynamic dimension based on a slicer, to do this I could use the switch function to populate a column based on a measurement such as max or min from a detached t...