Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calcuting values in a Matrix

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
)


)