Forum Discussion

atpostdata's avatar
atpostdata
Frequent Visitor
3 years ago
Solved

How to get top5 values based on a field.

To retrieve the top 5 values from each category based on a specific field in Power BI,  I used below measure but it giving me all negative records.           Top5Negative Records = CALCULATE(...
General Comment
Need Help
Show and Tell
  • Ahmedx's avatar
    Ahmedx
    3 years ago

atpostdata's avatar
atpostdata
Frequent Visitor
3 years ago

yes,  I did but no luck.

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

show what the result should be

  • atpostdata's avatar
    atpostdata
    Frequent Visitor
    3 years ago

    I did round(values,2) and its working.