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

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] )
    )

Forum Discussion

Need Help with measure

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure