Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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])
Solved! Go to Solution.
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,
Could you please mark the proper answers as solutions?
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
100 | |
98 | |
88 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |