Hi @jamie.bryan
Thanks for your answer!!
In terms of creating the calculated column, that is doable. However, my main challenge is how I could allow the user of the dashboard through a radio button in the dashboard to by changing the selection to have the column recalculated based on the selection. The only way I have been able to do something similar is by having a radio button selecting one option and a measure pointing out to different columns based on the selection. However, that would mean to create many different columns, something quite challenging when trying to include many different possible options.