Custom Parameter Changer from User

[andmo]

Hello Together,

is it possible to create a text input box that actively changes a parameter?

For understanding:

I have a table with values and this should be able to be changed actively by the report user. E.g. as discount input

Total price - Discount

Is it possible to do this with a new column or a SQL query? The total prices are fixed in a SQL Database database. The discount field should be calculated after the user input and output.

Thanks for your help

[andmo]

I will try to describe it better.
So i have a Table with Customer, Type, Total Preis and a Paramter Discount. When the user changes the parameter, the values in the table should also change.
The Discount column is calculated by Total*Paramter/100

[vojtechsima · Accepted solution]

Hi, @andmo ,

all right then, your Discount should be calculated as Measure.

Like this:

Discount = [Total Sum] * DIVIDE(SELECTEDVALUE(Parameter[Parameter]), 100)

Please note that the selectedvalue except a column from your parameter table and it can have different name.

[vojtechsima]

Hello,

I am not exactly sure what you mean. But you can have parameters bind with predefined text options, so whenever the user selects in the report the option will then proceed in the actual SQL Query.

Here's nice tutorial how it works:

https://www.youtube.com/watch?v=L-wqwzj0-Xo&t=270s