Forum Discussion
Numeric Range Parameters is not working - 2024
Thanks for your concern about this issue, Jihwan_Kim .
And huseyincenik , I would like to add a few points that may be helpful. Your formula is returned to the calculated table, which is a static result. It does not dynamically return results based on the dynamic filtering of slicers or filters.
In Power BI, there are three fields that can be created: Measure, Calculated Column, and Calculated Table.
Measures are dynamic, while calculated columns and calculated tables are static.
About more differences or details among them, you could refer to
Measure vs Calculated Column: The Mysterious Question? Not! - RADACAD
In summary, numeric range parameter is not available in calculated column or calculated table which is set by default.
In fact, in the official document provided by Jihwan, this sentence also confirms this.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your concern about this issue, Jihwan_Kim .
And huseyincenik , I would like to add a few points that may be helpful. Your formula is returned to the calculated table, which is a static result. It does not dynamically return results based on the dynamic filtering of slicers or filters.
In Power BI, there are three fields that can be created: Measure, Calculated Column, and Calculated Table.
Measures are dynamic, while calculated columns and calculated tables are static.
About more differences or details among them, you could refer to
Measure vs Calculated Column: The Mysterious Question? Not! - RADACAD
In summary, numeric range parameter is not available in calculated column or calculated table which is set by default.
In fact, in the official document provided by Jihwan, this sentence also confirms this.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous .Would you consider this as user feedback and update PowerBI on this issue? It's really interesting that this doesn't happen. Why do we do TOPN filtering only in a limited way via filter? This also works in other BI Tools like Tableau!