cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## 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 vendedores los cuenta, pero que tendria que filtro tendria que agregar a la formula para tener los que sean en la fecha "01/12/2017"

Agentes 2017 = CALCULATE(COUNTX(Data_Ingresos;Data_Ingresos[Red]);Data_Ingresos[Mes])

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: formula Contar

Hi @gabcar,

You can drag these columns together simply like below. The measure could be:

`Measure = Count('table1'[Vendedor])    // or distinctcount()`

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Microsoft

## Re: formula Contar

Hi @gabcar,

```Agentes 2017 =
CALCULATE (
COUNTX ( Data_Ingresos; Data_Ingresos[Red] );
Data_Ingresos[Mes] = DATE ( 2017; 12; 1 )
)
```

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: formula Contar

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
Microsoft

## Re: formula Contar

Hi @gabcar,

You can drag these columns together simply like below. The measure could be:

`Measure = Count('table1'[Vendedor])    // or distinctcount()`

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft

## Re: formula Contar

Hi @gabcar,

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!