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 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. 

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.

     

     

     

     

3 Replies

  • 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. 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.