topic Calculate Winning Party for every county in state for election in App Development

Calculate Winning Party for every county in state for election

prpranav — Thu, 08 Aug 2019 18:56:25 GMT

Hey everyone!

I'm working with state voter data, and I'm trying to create a chart with the winning party on each county . I have all the data organized in one central table.

The data table lists number of votes the candidate won in each precinct (subset of county). A preview of the data table is attached below.

As a measure, I tried :

FirstSortedValue( [Party], -aggr( sum([Candidate Votes]), [Candidate]))

but it returns only the party that won the entire election, not each county (a picture is attached below).

I believe the firstsortedvalue() is adding up all the votes in all counties and only returning one value for the winning party, but I'm not sure how to solve it. Any help would be appreciated.

Thank you!

Re: Calculate Winning Party for every county in state for election

Lisa_P — Fri, 09 Aug 2019 00:08:14 GMT

Same as my other answer:

FirstSortedValue( [Party], -aggr( sum([Candidate Votes]), [Candidate], Party))

Re: Calculate Winning Party for every county in state for election

prpranav — Fri, 09 Aug 2019 06:43:09 GMT

This is still resulting the same result 😞

Is there another way to make the calculation?