Forum Discussion

ArquimedesP's avatar
ArquimedesP
Icon for Helper II rankHelper II
5 years ago
Solved

Need Help with measure

Hi guys, i have a table wiht this columns:   Fecha Atrasos2 Atrasos3 Capital_MN 30/9/2018 5 5 478 31/10/2019 40 40 9821 30/11/2019 56 56 8425 31/12/2019 87 87 478 3...
Measures
  • Fowmy's avatar
    Fowmy
    5 years ago

    ArquimedesP 

    Use the measure given below:

    SUMAPRODUCTO CARTERA =
VAR __V =
    SELECTEDVALUE ( Table[VAlue], "Normal" )
RETURN
    DIVIDE (
        SUMX (
            VW_Cartera,
            IF (
                __v = "Covid",
                VW_Cartera[Atrasos3] * VW_Cartera[Capital_MN],
                VW_Cartera[Atrasos2] * VW_Cartera[Capital_MN]
            )
        ),
        SUM ( VW_Cartera[Capital_MN] )
    )



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

ArquimedesP 

Use the measure given below:

SUMAPRODUCTO CARTERA =
VAR __V =
    SELECTEDVALUE ( Table[VAlue], "Normal" )
RETURN
    DIVIDE (
        SUMX (
            VW_Cartera,
            IF (
                __v = "Covid",
                VW_Cartera[Atrasos3] * VW_Cartera[Capital_MN],
                VW_Cartera[Atrasos2] * VW_Cartera[Capital_MN]
            )
        ),
        SUM ( VW_Cartera[Capital_MN] )
    )