Count rows visible in table

[Pbiuserr]

Hello,

I have a table and I would like to create a measure which will display number of rows displayed in the table (including all filters, slicers etc) 

Was thinking of COUNTROWS ( ALLSELECTED ( [Fact Table] ) ) but it doesnt really tell the correct number 

I have ID from fact table and rest of columns from referential tables

[SpartaBI]

@Pbiuserr hey can you share a sample data and the explain the visual you want to create.

[Pbiuserr]

Hey,

Visual is already created (table). It's a drillthrough page, and table inside it (ID from fact table and bunch of dimensions associated from referential tables). I want to count all lines visible in the drillthrough. So if somebody drills on 2 rows, the count will be 2, if on 2000 the count will be 2000.

Seems like COUNTROWS ( ALLSELECTED ( Fact Table) ) or COUNTROWS ( ALLSELECTED ( Fact Table[ID] ) ) will do the job but I am not entirely convinced if its most efficient way.Moreover I struggle to add this measure to the table, for some reason. If its normal table in the page then its fine but not in this drillthrough worksheet

[SpartaBI]

@Pbiuserr do you want maybe to look at it together in zoom?
https://us05web.zoom.us/j/86882034498?pwd=bUFhL2d2bWxORURqdTdCN0x6elpvZz09

[Pbiuserr]

Hey. 
I'd love too but I think the client would not approve to have 3rd party looking at his company data 😞 and preparing some sample data, yes I might but its standard data, fact table and bunch of referential tables so Idk why its so slow

[SpartaBI]

Amm..ok so let's wait and see if someone else understand and if not prepare a replica with demo data and we could look together in zoom