find election winner

Hi,dilbagsidhu .
Thank you for your reply.
According to your description, the code I provided does not give the correct result in your computing environment.
From the screenshot you provided, it appears that you are using a matrix to display the results, could you please tell me if the screenshot you are displaying is the result of a direct calculation using the code I provided.
Unfortunately, the result can be affected by several external filters, for example, Total Votes in your matrix is affected by the current row. What I want to express is that the solution I provided is correct in my calculation environment, but the actual calculation environment is much more complicated than when I tested it. for example :in filter() function ,Screened for sex, so the code will not get the correct result in your calculation environment.
So can you provide some non-sensitive data (if not the basic data, can you provide the code for the measure you showed in the screenshot)
This will help to solve your problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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