Create table with what-if parameters

Hi John117 

Try this:

• Create a table with one column with the Value names
• Create the measure below

I used an IF() but use a SWITCH () if there are more values.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Value table =
VAR _curValue1 = 'Value 1'[Value 1 Value]
VAR _curTableValue =
    MAX ( newtable[Value] )
VAR _curValue2 = 'Value 2'[Value 2 Value]
RETURN
    IF ( _curTableValue = "Value 1", _curValue1, _curValue2 )