Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😁
Solved! Go to 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.
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.
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...
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |