Forum Discussion
How to create a global variable and use it?
Suppose we have a table of rows that have a column we'll call X. We want to add a calculated field to the model for that table which would have a value of f(x), where the function does something like multiply the value of X by a user-defined value which I'll call N. We want to allow the user to change the value of N on the dashboard using a slider, so they can manipulate the value of f(x).
I'm thinking we need to define a free-standing variable (not a column in the rows of the data model) for N, which is acts like a context variable. We can then reference that variable in DAX to compute f(x), and we can point a slider to N, allowing the user to increase or decrease its value.
How do we create that variable, so it can be referenced in DAX and by the slider?
1 Reply
hi Anonymous
Try to
1)create a calculated table like:
Parameter =
SELECTCOLUMNS(
GENERATESERIES(1, 10, 1)
"N", [Value]
)
2)plot a slicer with Paremeter[N] column
3)use SELECTEDVALUE(Paremeter[N]) in your code to capture the value.
