Forum Discussion

huseyincenik's avatar
huseyincenik
Frequent Visitor
2 years ago
Solved

Numeric Range Parameters is not working - 2024

I created a numeric range parameter. I used the parameter in TOPN, but the parameter does not appear in TOPN. When I add the parameter value as a column to a chart, I see the value I selected. ...
Data Protection
General Comment
Interesting Links
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

huseyincenik's avatar
huseyincenik
Frequent Visitor
2 years ago

Thank you for your answer. My parameter is created between 1 and 20 and aims to display TOPN. It is not affected by the restrictions you specify. What surprises me is that it appears when I define the parameter as values in a chart. But when I write it in dax as above, it is taken as 0.