Card showing count of rows in a visual table

[JeremyM]

Hi,

I have a visual table as follows:

Vehicle Licence	Current Status	Count of ID
11111	Live	15
22222	Staging	12
33333	Live	17

I'm wanting to display the number of rows in this visual table in a new card.

The table has filters on for the types of Current Status to display and the Count of ID must be greater than 10.

How do I create a measure (I'm assuming a measure is the way to go?) to display the number of rows only. In this case it is 3.

If Vehicle Licence is clicked, then this table adjusts to only show that row, and the card should adjust to show 1.

Is this something that is possible? I'm finding it very confusing.

Thanks.

[sergej_og]

Do you mean something like  this?
Measure_name = COUNTROWS(your_table)

Regards

[JeremyM]

Not exactly, as I don't want to measure the number of rows in the data table, but in the visual table. So what is being displayed. Or am I missing that there is a way to address a visual table? I can only see how to reference a data table.

[sergej_og]

What do you expect as output? I did´t catched it.
Can you show (in Excel maybe)?

Maybe you will need a virtual table for your purpose

[JeremyM]

Hi, see the image above - it shows my visual table (redacted some information), along with a pie graph and a card with the number of vehicles. I would like this card to display the number of rows in the visual table on the left.

If one of the items in the pie graph is clicked, it filters the table on the left. I would like the card of vehicle count to adjust as well. 

There are also filters on the page as well as on each visual component of Count of ID > 19 and to only have certain Statuses.

The information Vehicle Licence and ID are in one data table, and Current Status is in another data table. There is a link between the tables.

This doesn't translate onto the card or the pie graph. 

The data in each table looks like this

As you can see there are multiple rows per vehicle licence.

ID		Vehicle Licence
12345		11111
12346		22222
12347		11111
12348		44444
12349		22222
12350		33333
12351		11111

Table with Status data

Vehicle Licence		Status
11111		WARRANTISSUED
22222		STRATWARRANT
33333		WARRANTISSUED
44444		DRWARRANT

I'm not sure if this gives you enough information to understand what I am trying to do?

Thanks