Forum Discussion

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago

Count rows visible in table

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 (...
Need Help
Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago

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

  • Pbiuserr's avatar
    Pbiuserr
    Post Prodigy
    4 years ago

    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's avatar
      SpartaBI
      Community Champion
      4 years ago

      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