Create a Card showing the number of Rows in a Visualization (a Table)

[Sixian]

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

[Johanno · Accepted solution]

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?

[Johanno · Accepted solution]

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?

[Sixian]

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 · Accepted 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.

[Sixian]

Great! It works very well!

Thank you!

[D3nnisd]

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