How to get count of number of rows from a table visual

[psyche2k]

I want to write a measure to get a title which will show the no.of rows visible in the table after applying the filters.

For reference:
In the pic, no of document IDs that have [A_regFormat] = "EU" are 27 and [A_regFormat] = "Other" are 173 after the other applied 'filter on pages' (status, Product status in.., A_GHS)
I want to show the title as ...SDS (27 to 173...)...

How do I write the measure to acheive this?

Thanks.

[olgad · Accepted solution]

"SDS(" &Calculate(Countrows(Table you are using to feed the visual), [A_regFormat] = "EU") & "to " & Calculate(Countrows(Table you are using to feed the visual), [A_regFormat] = "Other")&")"