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

Hi,
File is blank.

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

    can't be.
    check again

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

    • atpostdata's avatar
      atpostdata
      Frequent Visitor
      3 years ago

      for value .99 it gives diiferent ranking

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

        what should be?
        did you try to change DESC to ASC