You can use a parameter to solve this. You should use a string parameter, filled with the names of your metrics.
Lets say your column with the 25 metrics is called “metrics” and your measure in the value column is called “value”.
ifelse({metrics} = "parameter1", {value}, NULL)))
or you use the sumif function:
sumIf({value}, {metrics} = "parameter1")
You can find the information about setting up a parameter here: Setting up Parameters