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

rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
3 years ago

atpostdata Hey, I gave you the exact solution you asked for. I wrote the measures also. And attached a screenshot of the result. Did you follow my steps? Do you need pbix?

atpostdata's avatar
atpostdata
Frequent Visitor
3 years ago

Hi ,
I followed the same steps, its working for negative overall_feedback value but not for postive as postive values rank is comming greater than 5. 
overall_feedback contains three values postive, negative and neutral.
need top 5 records from each category based on values field.