Help me with filters student achievement data and dax expression

[urayz]

Hello Everyone, need your guidances!

I have students achievements data that contains First Winner, Second Winner, Third Winner and other achivements.

From this data section, I just want to SUM the data with Big Three Winner Place and "Others" (value that other than First - Third Winner) Filters. So when I want to use the pie chart, the legends should be 4 items (First Winner, Second Winner, Third Winner, and Others), not more than 4 items.

Any recommendations DAX measure formula?

Thank you in advance and I hope you understand what I meant 😁

[dax · Accepted solution]

Hi @urayz , 

You could try to creat calculated column to achieve this goal, you could refer to my sample for details.

Best Regards,
Zoe Zhi

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

[amitchandak]

Please share some samplesdata. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...