Multiplying a value from parameter to a column

[anushkavp27]

Hello, 

I have a parameter value: 

New Slider: GENERATESERIES(0, 1, 0.05)

and then I have a measure: 

New Slider Value = SELECTEDVALUE('New Slider'[New Slider])

 

This is something that the user can slide through. 

I want to take this value and multiply it with a static column value: 

In thsi case, I want to multiply the value of the slider that was selected by the user with the Average Forecast column. So multiplied value = (36.77 * 0.8) , (37.00 * 0.8) and so on.

I understand that using a measure is the correct way of doing it, but I dont want to aggregate anything or use SUM expression. I want a simple multiplication of the average forecast and the value selected by the user. 

[Anonymous · Accepted solution]

Hi @anushkavp27 ,

I have created a simple sample, please refer to my pbix file.

Create a measure.

Measure = var _1= SELECTEDVALUE(Parameter[Parameter])
return 
_1*MAX('Table'[value])

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_]

Is average forecase a measure already? if so, then you can simply use a measure -

Multiplied Value = [Average Forecast] * SELECTEDVALUE('New Slider'[New Slider])

if it's not a measure, then:

Multiplied Value = SELECTEDVALUE('Table'[Average Forecast]) * SELECTEDVALUE('New Slider'[New Slider])

[anushkavp27]

Average forecast is not a measure. So, I tried the above command you gave, but it does not return anything. It gives all blank results.