Ranking List of Values In Powerpivot

[RKN]

How do I calculate a rank of values in a Powerpivot column (See 4th column below) while factoring in a condition (contained in column 2 below) for inclusion in the ranking calculation. For example:

1st Column: [Item Numbers] (contains unique item number for each row in the table)
2nd Column: [Groups] (all items either belong to group A or B)
3rd Column: [Values] (different values associated with each item number)
4th Column: [Ranking] (I want to calculate the individual rank of each of the item values in the 3rd column that belong to group A against only group A items (group B items should be ignored for the ranking))

Thank you!

 

[gazpage]

Probably something like.

[Ranking]:=
RANKX(
    FILTER(
        ALL ( Table ),
        Table[Groups] = Values ( Table[Groups] )
    ),
   SUM ( [Values] )
)

 

[GorD]

Mike at Excelsfun covers it here

https://www.youtube.com/watch?v=sfJWoQixi2U&t=1101s