Change Slicer selection to column title to select column SUM

[TreadSlim]

Hello,

I'm trying to get a slicer to choose a column name rather than the values in the column. Then return the sum of the column using a new column. Is this possible? Below is how I have it so far. Is there a value in place of 1 that can be used to represent the sum?

[amitchandak]

@TreadSlim , Not very clear. Check if field parameters can help

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf