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!
