Ability to Reference Field Parameter Value in DAX

[avisingh]

Problem

Field Parameters work great in visuals — you can switch between measures like Sales, Budget, and Forecast easily.

But in DAX, you cannot get the actual number of the selected measure.
If you try using:

SELECTEDVALUE('Parameter'[Parameter])

it always gives an error (“column is part of a composite key…”).

You can get the selected field name using:

SELECTEDVALUE('Parameter'[Parameter Fields])

But that only tells you which field is selected, not the value of that field.

So, to use that selection inside another measure, you have to rebuild everything using a big SWITCH() — which defeats the whole purpose of Field Parameters.

---

What We’d Like to See

We need a simple way for a Field Parameter to return the actual value (the number that the visual shows) directly in DAX.

For example, something like this:

Current Metric = PARAMETERVALUE('Metric Parameter'[Parameter])

This should give the same number that appears in the visual when that parameter is selected.

Why This Matters

• No need to rebuild logic with long SWITCH statements.

• Simpler and cleaner DAX models.

• Makes Field Parameters truly reusable — both in visuals and in measures.