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 lik...
FreemanZ
Super User
Super Userhi 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.