Calcuting values in a Matrix

[a-santiago]

Hello,

Im trying to make the next metric with the values in this Matrix:

Metric = (TIER1+TIER2)/TIER3     -->   from example : (5+7) / 404

what I cant figure out is how to make calculations with the values inside, because the values come from here:

How can I choose the values inside the Matrix to make the calculation
Thanks!

SUM_TRANSAC_LOCATION =

VAR aux =

    CALCULATE (

        SUM ( Fact_Safety_Synergie_Asset_Daily[Value] ),

        Fact_Safety_Synergie_Asset_Daily[Value] >= 0

    )

var __preventive_safety_observations =

CALCULATE (

    SUM ( Fact_Safety_Synergie_Asset_Daily[Value] ),

    Fact_Safety_Synergie_Asset_Daily[Attribute] = "iams_num_pso",

    REMOVEFILTERS(Fact_Safety_Synergie_Asset_Daily[iams_can_under_control_actions])

)

-- Lógica para accidentes de tráfico, donde se debe cumplir la doble condición para des_event_type y des_case_type_description

VAR __vehicle_crashes=

CALCULATE(

    DISTINCTCOUNT(

        Fact_Safety_Synergie_Asset_Daily[DES_CASE_ID]),

        Fact_Safety_Synergie_Asset_Daily[Attribute] in {"CAN_CATEGORY_S", "CAN_CATEGORY_O", "CAN_CATEGORY_M", "CAN_CATEGORY_C"},

        Fact_Safety_Synergie_Asset_Daily[DES_EVENT_TYPE]="Loss of vehicle control in land, maritime/river or air transportation",

        Fact_Safety_Synergie_Asset_Daily[DES_CASE_TYPE_DESCRIPTION] ="Repsol Control Incident Management  - Incident"

)+0

var __measure=    IF ( aux = BLANK (), 0, aux )

return

if(

    SELECTEDVALUE(

    Aux_Safety_Synergie_KPI[KPI_NAME_TABLE])="Preventive Safety Observations",

    __preventive_safety_observations,

        IF(

            SELECTEDVALUE(Aux_Safety_Synergie_KPI[KPI_NAME_TABLE])="Total Motor Vehicle Crashes",

                __vehicle_crashes,

    aux

)

)

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523