Forum Discussion
Create a Card showing the number of Rows in a Visualization (a Table)
I have a visualization in the form of a table. The values in the table change according to a slicer.
I want to add a Card that shows the number of rows in the table (excluding the header row). Of course, the value in the card will change according to the slicer.
Thanks
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?
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.
5 Replies
- Johanno
Continued Contributor
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?
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.
- Johanno
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.
I think making a measure with with =countrows would help.
https://msdn.microsoft.com/en-us/query-bi/dax/countrows-function-dax?f=255&MSPPError=-2147217396
