What is the basic DAX equivalent of INDEX MATCH?

For those much more familiar with Excel than PowerBI, I've used the following as an Excel equivalent for a simple way of conducting a weighted average calculation (similar to a simple SUMPRODUCT)

_SUMPRODUCT example = 

VAR _DESIREDROWS =
    FILTER (
        [Table Name],
        [Column of Data to filter on]  > [filter metric]
    )
RETURN
    DIVIDE (
        SUMX (
            _DESIREDROWS,
            [Value] * [Unit weighting]
        ),
        SUMX (
            _DESIREDROWS,
            [Unit weighting]
        )
    )

The above portion allows one to filter the data to a certain criteria, and the lower allows to calculate a weighted average, say for a baseball team's batting average.  

What would be the equivalent measure for INDEX MATCH?

for example, let's say one had a baseball team of players with a typical matrix of various statistical categories - batting average, home runs, etc.

In Excel, the programming would be =INDEX([entire table],MATCH( {player name},[column of player names],0),MATCH ( {statistical category}, [row of statistical categories],0))