Table Visualization: Getting total number of rows on current selection

[shhafiz]

Is there anyway we can get the count of rows that are currently selectd after applying all necessary filters?

One way I can think of is exporting the selection and then counting the rows in Excel. However, I am interested in showing this value along side the table.

How can I achieve this?

Thanks.

[v-huizhn-msft · Accepted solution]

Hi @shhafiz,

Try to create a measure using the formula below and check if it works fine.

result= COUNTROWS(ALLSELECTED(TableName))

Best Regards,
Angelia

[Ashish_Mathur]

Hi,

Try this calculated field formula

=COUNTROWS(Data)

Replace Data with your Table name.