Forum Discussion
Create a Card showing the number of Rows in a Visualization (a Table)
- 8 years ago
You could:
1. Make a copy of the table
2. Change the copied table to a card
3. Change the Fields to Count
Could that work as a solution?
- 8 years ago
Ok, you want to count by another column. You could delete the field and then choose another column, and set to count once again.
Or you could create a measure using
Count non empty rows = COUNT(Table[The column you want])
and put it in the card.
You could:
1. Make a copy of the table
2. Change the copied table to a card
3. Change the Fields to Count
Could that work as a solution?
- Sixian8 years agoFrequent Visitor
It works! Clever idea.
Just a clarification. When i choose the Card visualization, it chooses by default one of the values in the table. I change the summarization in a count and it is ok. In my case the value in the cecond column is chosen, but I would like to change it, because there could be some "void/missing" values in that column, so I could't get the total number of rows by counting tha values.
- Johanno8 years ago
Continued Contributor
Ok, you want to count by another column. You could delete the field and then choose another column, and set to count once again.
Or you could create a measure using
Count non empty rows = COUNT(Table[The column you want])
and put it in the card.
- Sixian8 years agoFrequent Visitor
Great! It works very well!
Thank you!