Count number of values?????

[Anonymous]

Hello,

I have a List with 2000 different values. And I have a Table with 25 Columns. I need the total count of every single value in this table. How can i realize this? It would take too much time to do 2000 COUNTA funtions for every column.. Any ideas???

Thanks in advance

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Are these 25 columns populated with the 2000 values? If so, you could get the expected result easily with Power Query. Steps are: Add an Index column to the table, right click on column header of the Index column and select Unpivot other columns. Select Value column, use Group by feature and select Count rows as operation. Then you will have what you want. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Anonymous , You have two for 25 columns only ?

Like

Counta(Table, [Col1]+[Col2]+[Col3])

or

Counta(Table, [Col1]) +Counta(Table, [Col2])

or

countx(union(all(Table[Col1]),Counta(Table, [Col2]). Counta(Table, [Col3]) ) , [Col1] ) 

[Anonymous]

But I need to see the number of count for every value like:

Value	Number of count
3444	12
7800	4