COUNT with filters

Question

Hola, necesito contar la cantidad de valores que tengo pero aplicando filtros.&nbsp;&nbsp;Ejemplo:&nbsp;ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; TIPO&nbsp;&nbsp;&nbsp;&nbsp;ASD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AZXC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BQWE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BRTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;Quiero que me cuente la cantidad de tipos que contienen "B".&nbsp;Muchas gracias.

greg_deckler · Answer

I'm not great with the Spanish, but perhaps try COUNTX with a FILTER?

v-jiascu-msft · Answer

Hi&nbsp;Muchas,
&nbsp;
How about dragging the columns in a Table visual and setting the aggregation of ID as "Count" while setting the aggregation of TIPO as "Don't summarize"?
&nbsp;
&nbsp;
Best Regards,

Forum Discussion

COUNT with filters

2 Replies

Related content

Filter participant counts

Filter and Count

Counting nulls

Help with matrices slicers, filters and dynamic counts

Count Of Drivers