Forum Discussion

anushkavp27's avatar
anushkavp27
Frequent Visitor
2 years ago
Solved

Multiplying a value from parameter to a column

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 someth...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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_'s avatar
vicky_
Super User
2 years ago

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's avatar
anushkavp27
Frequent Visitor
2 years ago

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.