Forum Discussion
Solved
formula Contar
Hola buenos dias, mi consulta es la siguiente tengo esta formula que me cuenta el numero de vendedores que tengo , pero necesito filtrar los que tenia en Diciembre 2017, la cantidad de vendedore...
Hi gabcar,
You can drag these columns together simply like below. The measure could be:
Measure = Count('table1'[Vendedor]) // or distinctcount()
Best Regards,
Dale
Hi gabcar,
Can you share a dummy sample, please? How about this one?
Agentes 2017 =
CALCULATE (
COUNTX ( Data_Ingresos; Data_Ingresos[Red] );
Data_Ingresos[Mes] = DATE ( 2017; 12; 1 )
)
Best Regards,
Dale
Hi Dale thanks for answer!
I have a table, one column Vendedor, another column month, I need to count how many Vendedor, are in month =01/12/2017
Im new with this dax formulas!
regards
Gabriel
| Vendedor | Month |
| Vendedor 1 | 1/11/2017 |
| Vendedor 2 | 1/11/2017 |
| Vendedor 1 | 1/12/2017 |
| Vendedor 4 | 1/12/2017 |
| Vendedor 5 | 1/12/2017 |
| Vendedor 6 | 1/12/2017 |
| Vendedor 7 | 1/12/2017 |
| Vendedor 8 | 1/12/2017 |
| Vendedor 1 | 1/01/2018 |
| Vendedor 2 | 1/01/2018 |
| Vendedor 11 | 1/01/2018 |
| Vendedor 12 | 1/01/2018 |
| Vendedor 13 | 1/01/2018 |
Hi gabcar,
You can drag these columns together simply like below. The measure could be:
Measure = Count('table1'[Vendedor]) // or distinctcount()Best Regards,
Dale