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

  • 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

      • atpostdata's avatar
        atpostdata
        Frequent Visitor
        3 years ago

        yes,  I did but no luck.