Display table in matrix

Tevon713 ,

try the below,

1. Create a static Table like the below by using attached M code,

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcgtxVXDOL80rUdJRMlSK1YGJFJcoqACFjJRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Metrics = _t, Index = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Metrics", type text}, {"Index", Int64.Type}})
in
    #"Changed Type"

2. Then load the data to Power BI desktop and then sort the metric column based on index column.
3. Then, Write the below 4 measures by changing the actual table of your dataset and use it in matrix visual.

Previous Year = 
VAR _previousYear = MAX('Test Matrix'[Year])-1
VAR _resultFTECostPreviousYear = CALCULATE(
    SUM('Test Matrix'[FTE Cost]),
    'Test Matrix'[Year] = _previousYear)
VAR _resultFTECountPreviousYear = CALCULATE(
    SUM('Test Matrix'[FTE Count]),
    'Test Matrix'[Year] = _previousYear)
VAR _result = 
            SWITCH(SELECTEDVALUE('Static'[Metrics]),
            "FTE Count",_resultFTECountPreviousYear,
            "FTE Cost $",_resultFTECostPreviousYear)
RETURN _result

Current Year = 
VAR _currentYear = MAX('Test Matrix'[Year])
VAR _resultFTECostCurrentYear = CALCULATE(
    SUM('Test Matrix'[FTE Cost]),
    'Test Matrix'[Year] = _currentYear)
VAR _resultFTECountCurrentYear = CALCULATE(
    SUM('Test Matrix'[FTE Count]),
    'Test Matrix'[Year] = _currentYear)
VAR _result = 
            SWITCH(SELECTEDVALUE('Static'[Metrics]),
            "FTE Count",_resultFTECountCurrentYear,
            "FTE Cost $",_resultFTECostCurrentYear)
RETURN _result

% = 
VAR _previousYear = MAX('Test Matrix'[Year])-1
VAR _resultFTECostPreviousYear = CALCULATE(
    SUM('Test Matrix'[FTE Cost]),
    'Test Matrix'[Year] = _previousYear)
VAR _resultFTECountPreviousYear = CALCULATE(
    SUM('Test Matrix'[FTE Count]),
    'Test Matrix'[Year] = _previousYear)
VAR _currentYear = MAX('Test Matrix'[Year])
VAR _resultFTECostCurrentYear = CALCULATE(
    SUM('Test Matrix'[FTE Cost]),
    'Test Matrix'[Year] = _currentYear)
VAR _resultFTECountCurrentYear = CALCULATE(
    SUM('Test Matrix'[FTE Count]),
    'Test Matrix'[Year] = _currentYear)
VAR _differenceFTECount = _resultFTECountCurrentYear-_resultFTECountPreviousYear
VAR _differenceFTECost = _resultFTECostCurrentYear-_resultFTECostPreviousYear
VAR _result = 
            SWITCH(SELECTEDVALUE('Static'[Metrics]),
            "FTE Count",DIVIDE(_differenceFTECount,_resultFTECountPreviousYear),
            "FTE Cost $",DIVIDE(_differenceFTECost,_resultFTECostPreviousYear))
RETURN _result

Difference = 
VAR _previousYear = MAX('Test Matrix'[Year])-1
VAR _resultFTECostPreviousYear = CALCULATE(
    SUM('Test Matrix'[FTE Cost]),
    'Test Matrix'[Year] = _previousYear)
VAR _resultFTECountPreviousYear = CALCULATE(
    SUM('Test Matrix'[FTE Count]),
    'Test Matrix'[Year] = _previousYear)
VAR _currentYear = MAX('Test Matrix'[Year])
VAR _resultFTECostCurrentYear = CALCULATE(
    SUM('Test Matrix'[FTE Cost]),
    'Test Matrix'[Year] = _currentYear)
VAR _resultFTECountCurrentYear = CALCULATE(
    SUM('Test Matrix'[FTE Count]),
    'Test Matrix'[Year] = _currentYear)
VAR _result = 
            SWITCH(SELECTEDVALUE('Static'[Metrics]),
            "FTE Count",_resultFTECountCurrentYear-_resultFTECountPreviousYear,
            "FTE Cost $",_resultFTECostCurrentYear-_resultFTECostPreviousYear)
RETURN _result

Result:

Thanks,

Arul