Global Parameters/Variables Table

[ConnieMaldonado]

Hello - Is there a way to set up a table to include variables that can be accessed in any calculation?  I thought I read that there's a way to do this, but I can't find it now.

For example, I have several tables that have geofencing data for field activities by technicians.  I want to filter all records with onsite duration < 5 minutes.  Currently, I've created a filter for each table, but I'd like to user a global parameter of 5 minutes so I can change the parameter once and have it filter all tables. 

Is there a best practice to do this?

Thanks.

[ConnieMaldonado]

That is awesome.  I was not aware of numeric range parameters.  However, I have many calculations in which I reference the filter (measures), so can I use the numeric range parameter there or only in visuals?  Thanks!

[DataInsights · Accepted solution]

You can use the numeric range parameter in other measures as well as visuals. It's essentially an interactive measure that allows a user to specify a value via a slider and have that value propagate throughout the report.

[DataInsights]

@ConnieMaldonado,

You can achieve this with a numeric range parameter.

1. Create numeric range parameter:

2. Create measure:

Onsite Duration Filter = IF ( MAX ( Fact[Onsite Duration] ) < 'Onsite Duration'[Onsite Duration Value], 1 )

3. Add measure Onsite Duration Filter to a visual:

4. Result:

-----