Forum Discussion
Scenario modelling tool
create a numeric range .you can set the min , max and the increment. ( 1, or 0.1 ..etc.. )
this will create a table ( in the image above called Paramter ) with one field.
then create a measure =
selectedvalue( Paramter[field_name]) , 1 )
then in your measure that calculates the sales price, you can multiply by the above measure,
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
create a numeric range .you can set the min , max and the increment. ( 1, or 0.1 ..etc.. )
this will create a table ( in the image above called Paramter ) with one field.
then create a measure =
selectedvalue( Paramter[field_name]) , 1 )
then in your measure that calculates the sales price, you can multiply by the above measure,
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
selectedvalue( Paramter[field_name]) , 1 )
what should be entered in field name? this has not been defined in the process??
the field name is the name of the column name created when creating the range .
like in my exmple,
the name is Paramter, so : selectedvalue(paramter[Paramter])
In this scenario, field name is just a generic name because we do not know exactly what it is named in your parameter. If you open the table that is automatically created when you setup the parameter, you will see a name for the column that stores the number values. This is what is meant by [Field_Name].
Hello,
I have done this and it works except for the fact that my number range should be anything between 1 and 1,000.000. But because parameters can only have 1,000 unique values it doesn't work. Is there a way around this?
