Hi Josh,
Thanks for the feedback on parameterized formulas. Thats not something we support today but are definitely thinking about for the future.
CurrentValue has two places where it really works well static lists and columns. It is intended as a way to operate on each individual instance with a few specific formulas like FormulaMap and Filter. It does require a specific piece of data to operate over, and without it as you noticed the formula will complain that it can’t find any reference called CurrentValue because it won’t work in the current context.
Just for reference if you have a numeric column in a table you could do something like [Table].[Number Column].Filter(CurrentValue > 1000000 AND CurrentValue < 5000000) which would return a list of all values in the specified range.
If you are just trying to write a filter for a table view you would want to use the column name instead of CurrentValue.
Hope that helps!
Jason