Top value in a category based on 2 columns

[aqavi10]

Hi everyone,

  Can someone please help me accomplish this task below? I need to display the store with the highest sales in a 'Card' visual. This needs to be categorized based on the 'State' and the 'Year'. Ultimately, I would want to slice by 'Year' and 'State' and the 'Card' visual should display the store with highest sales in that 'State' in that 'Year'. 

The data below has sales for 2018 & 2019 and is a sample for a few stores. I have tried to create a calculated table where after using the Rank & Filter function , I was able to get a table with top rank/'Rank1' stores(ranked by sales) for each state in 2018 & 2019. But I'm unable to connect it with the main data table since it is a many to many relationship and the keys to connect would be 'Year' &'State' but it would only use 1 relationship to connect.

Thank you

Week	Year	Month	StoreName	State	TotalDollarSales
11	2018	March	Store Wynnum West	Queensland	10239.24
11	2018	March	Store Maroochydore	Queensland	11972.33
11	2018	March	Store Bairnsdale	Victoria	12706.75
11	2018	March	Store Mosman Park	Western Australia	5730.57
11	2018	March	Store Beenleigh	Queensland	11705.45
11	2018	March	Store Armadale	Western Australia	10301.74
11	2018	March	Store Belmont Forum (Rebadge 368)	Western Australia	17674.32
11	2018	March	Store Findon	South Australia	12890.7
11	2018	March	Store Katoomba	New South Wales	9662.39
11	2018	March	Store Camden	New South Wales	8156.99
11	2018	March	Store Kurri Kurri	New South Wales	19059.99
11	2018	March	Store Bay City (Geelong)	Victoria	5772.15
11	2018	March	Store Bondi Junction Eastgate	New South Wales	12090.18
11	2018	March	Store Port Adelaide Church Street	South Australia	17561.86
11	2018	March	Store Palmerston	Northern Territory	10243.56
11	2018	March	Store Braybrook	Victoria	12917.27
11	2018	March	Store Kaleen	Australian Capital Territory	6310.24
11	2018	March	Store Chisholm	Australian Capital Territory	7865.25
11	2018	March	Store Waniassa	Australian Capital Territory	7469.3
11	2018	March	Store Alexander Heights	Western Australia	12050.61
11	2018	March	Store Lutwyche	Queensland	8639.26
11	2018	March	Store Paralowie	South Australia	9039.99
11	2018	March	Store Engadine	New South Wales	8723.82
11	2018	March	Store Ferntree Gully	Victoria	7688.41
11	2018	March	Store Fairfield (QLD)	Queensland	8118.32
11	2018	March	Store Dandenong Plaza	Victoria	15150.77
11	2018	March	Store Mount Barker (Cameron Street)	South Australia	14722.16
11	2018	March	Store Parramatta North	New South Wales	11126.07
11	2018	March	Store Wattle Grove	New South Wales	12526.99
11	2018	March	Store Mowbray	Tasmania	9864.16
11	2018	March	Store Devonport	Tasmania	16066.54
11	2019	March	Store Wynnum West	Queensland	10739.24
11	2019	March	Store Maroochydore	Queensland	12472.33
11	2019	March	Store Bairnsdale	Victoria	13456.75
11	2019	March	Store Mosman Park	Western Australia	6230.57
11	2019	March	Store Beenleigh	Queensland	12205.45
11	2019	March	Store Armadale	Western Australia	10801.74
11	2019	March	Store Belmont Forum (Rebadge 368)	Western Australia	18174.32
11	2019	March	Store Findon	South Australia	13390.7
11	2019	March	Store Katoomba	New South Wales	10162.39
11	2019	March	Store Camden	New South Wales	8656.99
11	2019	March	Store Kurri Kurri	New South Wales	19559.99
11	2019	March	Store Bay City (Geelong)	Victoria	6272.15
11	2019	March	Store Bondi Junction Eastgate	New South Wales	12590.18
11	2019	March	Store Port Adelaide Church Street	South Australia	18061.86
11	2019	March	Store Palmerston	Northern Territory	10743.56
11	2019	March	Store Braybrook	Victoria	13417.27
11	2019	March	Store Kaleen	Australian Capital Territory	6810.24
11	2018	March	Store Chisholm	Australian Capital Territory	9853.25
11	2018	March	Store Waniassa	Australian Capital Territory	6933.52
11	2019	March	Store Alexander Heights	Western Australia	12550.61
11	2019	March	Store Lutwyche	Queensland	9139.26
11	2019	March	Store Paralowie	South Australia	9539.99
11	2019	March	Store Engadine	New South Wales	9223.82
11	2019	March	Store Ferntree Gully	Victoria	8188.41
11	2019	March	Store Fairfield (QLD)	Queensland	8618.32
11	2019	March	Store Dandenong Plaza	Victoria	15650.77
11	2019	March	Store Mount Barker (Cameron Street)	South Australia	15222.16
11	2019	March	Store Parramatta North	New South Wales	11626.07
11	2019	March	Store Wattle Grove	New South Wales	13026.99
11	2019	March	Store Mowbray	Tasmania	10364.16
11	2019	March	Store Devonport	Tasmania	16566.54