Need Help with measure

Question

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
31/1/2020	10	0	1000
28/2/2020	50	0	2000
31/3/2020	1	0	50
28/4/2020	12	0	700
31/10/2020	2	0	800
30/11/2020	1	0	1550
31/1/2021	10	0	1205
28/2/2021	600	600	200
30/4/2021	20	20	355

Atrasos2: They are the days behind without taking into account the covid issue.

Atrasos3: It is a calculated column where if the dates are between 31/01/2020 and 31/01/2021 (covid issue), the days of arrears are zeroed.

I also have this measure:

SUMAPRODUCTO CARTERA = SUMX(VW_Cartera,VW_Cartera[Atrasos2]*VW_Cartera[Capital_MN])/SUM(VW_Cartera[Capital_MN])

I want to create this filter:

And even I need the measure to calculate with the column "Atrasos2" when I select "Normal" or do not select anything, and to calculate with the column "Atrasos3" when I select "Covid".

How should i do it?

Thanks

fowmy · Accepted Answer

ArquimedesP&nbsp;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

2 Replies

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure