The same Measure but distinct dates

[Hector78]

Hello.

I have a table like this

Código	F.INI_PARTIDA	F.FIN_PARTIDA
	SIN FECHA	10
	SIN FECHA	12
	10	2019
	1	12
	1	2019
	9	2019
	10	2019
	SIN FECHA	SIN FECHA
	SIN FECHA	6
416332	1	1
	SIN FECHA	SIN FECHA
413111	1	1
	1	12
	SIN FECHA	SIN FECHA
418325	1	6
418074	1	6
415902	1	6
	1	2019
	SIN FECHA	SIN FECHA
	2	10
	SIN FECHA	SIN FECHA
	SIN FECHA	SIN FECHA
	1	2019
	SIN FECHA	SIN FECHA
	SIN FECHA	SIN FECHA
419426	1	12

I would like to build two measures. The first one, a measrure that would obtain the number of Codigo_Clarity by F.INI_PARTIDA and the other one by F.Fin_Partida and put them in the same graph such in the attached image

With this dataset for the Month 1 the first Measures would be 11 and the second Measure would be 2.

For the Month 2 the first Measure would be 1 and second one would be 0.

Thank you in advance.

[CadgiRo · Accepted solution]

With a isolated table for months, yo can do something like this:

VALOR_A_BUSCAR =

IF (

             HASONEVALUE( Meses[Mes] );

             VALUES( Meses[Mes] );

             "ERROR"

)

Columna1 =

CALCULATE(

      COUNTROWS( Facts );

      FILTER(

             Facts;

             Facts[F.INI_PARTIDA]=[VALOR_A_BUSCAR]

      )

)

Columna2 =

CALCULATE(

      COUNTROWS( Facts );

      FILTER(

             Facts;

             Facts[F.FIN_PARTIDA]=[VALOR_A_BUSCAR]

      )

)

tell me if it's useful

[Hector78]

Perfect.

Thank you very much.