Retrieve MAX row of SUMMARIZE table

[danialsj]

I have used the SUMMARIZE DAX in a calculated column and the result is somthing like this (within the SUMMARIZE table):

Branch	Revenue
2	33000
1	22500
3	12000

I want to retrieve the branch with the highest Revenue.
E.g. I want the calculated column to say 2 since it has the max revenue. 

My DAX looks like this currently:

MaxBranch =

var ID = Table1[ID]

var BRANCHCODE = Table1[BranchCode]

var IDTABLE = CALCULATETABLE(Table1, FILTER(Table1, Table1[ID] = ID))

var SUMTABLE = SUMMARIZE(IDTABLE, Table1[ID], Table1[BranchCode], "Branch", Table1[BranchCode], "Revenue", SUM(Table1[Revenue]))

return

MAXX(SUMTABLE, [Revenue])

In the above, I was only able to retrive the highest revenue. SUMTABLE is a grouping of revenue totals by ID then Branch. When I write MAXX(SUMTABLE, [Branch]) then it picks up branch 3 as that is the highest number value. However I want it to first find the highest revenue value and output the corresponding branch. Thanks!

[amitchandak · Accepted solution]

@danialsj , Assuming Revenue is a measure like Sum(table[Revenue])

Top 1 Branch Revenue Rank = CALCULATE([Revenue],TOPN(1,all(Table[Branch]),[Revenue],DESC),VALUES(Table[Branch]))

https://youtu.be/QIVEFp-QiOk

[amitchandak · Accepted solution]

@danialsj , Assuming Revenue is a measure like Sum(table[Revenue])

Top 1 Branch Revenue Rank = CALCULATE([Revenue],TOPN(1,all(Table[Branch]),[Revenue],DESC),VALUES(Table[Branch]))

https://youtu.be/QIVEFp-QiOk

[danialsj]

Thanks! I changed some things around the DAX you sent and it has worked. 

MAXX(TOPN(1, SUMTABLE, [Revenue],DESC), [Branch])

[wdx223_Daniel · Accepted solution]

RETURN

MAXX(TOPN(1,SUMTABLE,[Revenue]),[Branch])