Forum Discussion
The same Measure but distinct dates
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.
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
2 Replies
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