Summarize Table by Max Value index

[Anonymous]

This is the table that I have. I'm trying to make a summary table that only grabs the rows with the largest value index. In this sample data, it would be Index value 9.

Thank you!

[az38]

Hi @Anonymous 

try

Table = 
var _maxIndex = CALCULATE(MAX(Table[Index]), ALL(Table))
RETURN 
FILTER(Table, Table[Index] = _maxIndex)

[Anonymous]

@az38 

This worked great for one value, how would I modify this if I have multiple G1ROLL values with Separate index's? 

Here's a picture of what I'm referencing.

[az38]

@Anonymous 

try

Table = 
var _maxIndex = CALCULATE(MAX(Table[Index]), ALLEXCEPT(Table, Table[G1ROLL]))
RETURN 
FILTER(Table, Table[Index] = _maxIndex && Table[G1ROLL] = MAX(Table[G1ROLL]))

[Anonymous]

@az38 

This had no errors but it returned no rows. There's a potential case where the indexes might have a duplicate and it would be okay if it pulls that duplicate.

[az38]

@Anonymous 

sorry, my bad.try

Table 2 = 
FILTER(
ADDCOLUMNS(
'Table',
"R", RANKX(FILTER('Table', 'Table'[G1ROLL]=EARLIER('Table'[G1ROLL])), 'Table'[Index], , DESC)
),
[R] = 1
)