Forum Discussion
Count value but in WHOLE TABLE ?
Hello,
I have more than 100 Columns an I need to count the numbers of some values across the whole table, not in single columns!
This is how I can count the number of eg. the value "5336" in a column, but I want to count it across all columns: COUNTROWS(FILTER(Kst,Kst[Kst1]="5336")).
Thanks in advance
Anonymous , One the way is to unpivot all the hundred columns. Then you will get one column and value and filter
COUNTROWS(FILTER(Kst,Kst[column]="5336"))
1 Reply
- amitchandak
Super User
Anonymous , One the way is to unpivot all the hundred columns. Then you will get one column and value and filter
COUNTROWS(FILTER(Kst,Kst[column]="5336"))