Use a field parameter in a column

[Bebs]

Hello,

I'm using a parameter  :

Modeling / New Parameter / Fields => select severals indicators. (let's call it Param1)

With this functionality I easily manage to create a button to select one indicator and to use it in a table.

I, now, would like to display column of this Param1 on dedicated year.

For example I'd like to have a column Param1 for Year 2022, another for Param1 Year 2021 and so on

I try something simple : to create a new Measure like this :

E_INDICATOR_2020 = CALCULATE(Param1, data[YEAR]=2020).

But I've this error message : "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

the problem is : The button using Param1 is set to only select one value. so It should works but no.

Do you know how to workaround this problem  ?

Regards

[lbendlin]

I'd like to have a column Param1 for Year 2022, another for Param1 Year 2021 and so on

That's not what parameters are for.  Use Slicer buttons for that.

[Bebs]

Hello,

are you saying it's not possible to use parameter in DAX in general ?

My point is, I'd like to be able to switch indicator in several calculations at a time.

I was planning to use a parameter to get the name of the indicator then use this parameter in my DAX calculations. But every time I want to write some DAX with a parameter it does not seems to work.

Best regards.

[lbendlin]

DAX Parameters cover columns (or collections, if you want). What you are trying to do is cover values. Use slicers to cover values.

[Bebs]

Thanks for the anwser,

I'm not sure to be trying to cover a value, I think I'm trying to use a value to be used as a column name.

I don't understand how I could select indicators (choose between Turnover or Margin for instance) in a table using a slicer ?

I would like the user to first select an indicator name (Turnover or Margin) for example with buttons, then use this indicator name to modify values in table's indicators. But in this table, some columns are calculations on values (for example : calculate Turnover/Margin of the last year vs the Turnover/Margin of last year).

Using a parameter works to select an indicator with buttons, to change values in a table IF there are no calculation ; when I try to use DAX to add a calculation on the table it doesn't seems to work. Do you have an idea to solve the issue ?

Regards.

[lbendlin]

first select an indicator name (Turnover or Margin) for example with buttons

you use (single select) slicers, not buttons - but you can make them look like buttons with horizontal layout.

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.