How to create a global variable and use it?

[Anonymous]

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?

[FreemanZ]

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.