Need Help with measure

ArquimedesP — Wed, 02 Jun 2021 19:36:57 GMT

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

Re: Need Help with measure

Fowmy — Wed, 02 Jun 2021 19:46:00 GMT

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

Re: Need Help with measure

ArquimedesP — Wed, 02 Jun 2021 20:54:30 GMT

it worked perfectly! Thanks a lot!

topic Re: Need Help with measure in DAX Commands and Tips

Need Help with measure

Re: Need Help with measure

Re: Need Help with measure