multiplier

[AlessandroBet]

I need to moltiply the numbers inside a table selecting the multiplier from a "slicer" and also able to select the steps

ex: 10.1, 10,2, 10,3 ...etc

I have a table with the total revenue and i want calculate the margin selecting the value (%) from slicer

Can you help me?

[AlessandroBet]

I have insert thie new column:

#Column = VALUE('Forecast (Billing)'[Billing])*'Autodesk New'[Autodesk New Value]

where "Autodesk New'[Autodesk New Value]" is the value calculated by slider but it does change 

Could you help me?

[stefani_vileva]

I don't understand what you mean. Can you explain to me what do you want to do with the new column?

[AlessandroBet]

many thanks it works

I have other 2 questions

1) How can i make a moltiplication between the slider value and existing value?

2) Can i set the default value reading a measure?

[stefani_vileva]

1. You create a measure in which you multiply every value with the value from the slicer.

2. What do you mean by setting default value reading a measure? Usually, you can take the minimum or maximum value of the slicer as default value.

[AlessandroBet]

1. Ok

2. I would like to set the default value coming from other measure calculated

[stefani_vileva]

In the measure of the paramter table you have the following formula 

Parameter Value = SELECTEDVALUE('Parameter'[Parameter], Insert_your_measure).

If you want a default value, you can put it as second argument of the function selected value.

[AlessandroBet]

can anyone answer to my questions?

[vicky_ · Accepted solution]

Go to Modelling > New Parametr > Numeric Range and make sure to use "Add a slicer to this page". Your users can then use a slicer to select the percentage multiplier.