Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rand() recalculated within TOPN

The data table used is below        I have a slicer  nValue, with values from 1 to 20. Case 1 (working as expected): Based on the slicer selection, the data table should show the top  product...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

     

    Measure Random and Measure Top_Random perform different random number calculations. The random number generated by Measure op_Random is not the same as the random number generated by Measure Random.

     

    And due to the characteristics of the TOPN function, the returned result may be more than N rows.

    • If there is a tie, in order_by values, at the N-th row of the table, then all tied rows are returned. Then, when there are ties at the N-th row the function might return more than n rows.

    You can read these articles below for more information

    Refer:

    Filtering the Top 3 products for each category in Power BI

    Filtering the top products alongside the other products in Power BI

    Showing the top 5 products and Other row

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Anonymous 

 

Measure Random and Measure Top_Random perform different random number calculations. The random number generated by Measure op_Random is not the same as the random number generated by Measure Random.

 

And due to the characteristics of the TOPN function, the returned result may be more than N rows.

  • If there is a tie, in order_by values, at the N-th row of the table, then all tied rows are returned. Then, when there are ties at the N-th row the function might return more than n rows.

You can read these articles below for more information

Refer:

Filtering the Top 3 products for each category in Power BI

Filtering the top products alongside the other products in Power BI

Showing the top 5 products and Other row

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.