Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
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:
-----
Proud to be a Super User!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |