Problem with parameter

[capko]

Hello,

I've created a parameter (first time) that it doesn't seem to work.

The parameter is associated to a slicer which can go from 1 to 5 in steps of 1.

I've created a test table with a column called "Test" and I'm trying to create another column in order to multiply the value from "Test" by the parameter value but nothing shows up...

Does anyone know why ?

[Anonymous · Accepted solution]

Hi, @capko 

Thanks for @rajendraongole1 reply. You can refer to the following explanation.

The Parameter table is generated by GENERATESERIES, which creates a table with a single column of values ranging from 1 to 5. However, when you use SELECTEDVALUE(Parameter[Parameter]) in a calculated column, Power BI does not know which specific value from the Parameter table to use for each row in the calculated column because calculated columns are evaluated for every row in the table.

To use a parameter in a calculated column, you would typically create a measure, as measures can change based on context (such as filters or slicers), whereas calculated columns are static and cannot be context-aware in the same way.

So, the environment where Numerical Parameter is most applicable is Measure rather than Calculate columns.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[capko]

It doesn't work for me... I think the problem is that I have the Parameter and the table I'm trying to use separated. How did you put the parameter in the same group as the table ?

 

[rajendraongole1]

Hi @capko - In your parameter calculation , Instead of using the [Parameter value] highlighted with Red color. you have you use Parameter highlighted with Green color as below. it works with your [test] measure. check it and let know.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!