Forum Discussion
Global Parameters/Variables Table
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.
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.
3 Replies
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:
-----
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!
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.
