Creating a measure to swap parameters depending on column value

[dillanb123]

Hello,

I am having issues trying to swap multiple parameters into a single measure depending on a column value.  For example: if we have 2 parameters, [Parameter for Type A Value] = 50, [Parameter for Type B Value] = 100 I want them to show up in a table like this:

Type	Measure Value
A	50
B	100

I have tried something like: Measure Value = if(selectedvalue([Type]) = "A", [Parameter for Type A Value], if(selectedvalue([Type]) = "B", [Paremeter for Type B value]))

Any tips for this would be greatly appreciated

[dillanb123 · Accepted solution]

nevermind had to switch selectedvalue() with MIN() and it works now