Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
1.6 kB
1
Indexable
Never
Objetivo Input = 
VAR vSubtower = SELECTEDVALUE(MT_Cecos[SubTower CeCo])
VAR vRol = IF(USERPRINCIPALNAME() in {"n575308@santanderglobaltech.com", "n52990@santanderglobaltech.com", "n912448@santanderglobaltech.com", "n803214@santanderglobaltech.com"}, 1, 0)

VAR vInput_Customer = SELECTEDVALUE('Parámetro_COE_Customer'[Parámetro_COE_Customer])/100
VAR vInput_Data = SELECTEDVALUE('Parámetro_COE_Data'[Parámetro_COE_Data])/100
VAR vInput_BPM = SELECTEDVALUE('Parámetro_BPM'[Parámetro_BPM])/100
VAR vInput_CRM = SELECTEDVALUE('Parámetro_CRM'[Parámetro_CRM])/100
VAR vInput_FullStack = SELECTEDVALUE('Parámetro_FullStack'[Parámetro_FullStack])/100
VAR vInput_Testing = SELECTEDVALUE('Parámetro_COE_Testing'[Parámetro_COE_Testing])/100
VAR vInput_Retail = SELECTEDVALUE('Parámetro_COE_Retail'[Parámetro_COE_Retail])/100
VAR vInput_Shared = SELECTEDVALUE('Parámetro_Shared_Service'[Parámetro_Shared_Service])/100
VAR vInput_Solutions_Engineering = SELECTEDVALUE('Parámetro_Solutions_Engineering'[Parámetro_Solutions_Engineering])/100

RETURN IF(vRol = 1, 
            IF(vSubtower = 4093, vInput_Customer, 0)
            IF(vSubtower = 4092, vInput_Data, 0)
            IF(vSubtower = 4090, vInput_BPM, 0)
            IF(vSubtower = 4091, vInput_CRM, 0)
            IF(vSubtower = 408, vInput_FullStack, 0)
            IF(vSubtower = 403, vInput_Testing, 0)
            IF(vSubtower = 401, vInput_Retail, 0)
            IF(vSubtower = 400, vInput_Shared, 0)
            IF(vSubtower = 402, vInput_Solutions_Engineering, 0))