Forum Discussion
Sixian
8 years agoFrequent Visitor
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 co...
- 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.
D3nnisd
8 years agoFrequent Visitor
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