Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
5 years ago
Solved

Count rows in table

Hi all,

 

I shame me, but how and where do I create a measure(Table.RowCount) to count the number of rows in a table?

Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi Frixel 

    take a look at the figure:

     

     With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

5 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi Frixel 

    following example: Countrows = COUNTROWS(YourTable)

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

    • Frixel's avatar
      Frixel
      Post Prodigy
      5 years ago

      Hi FrankAT 

       

      Thanks, but in with cell i put that formule and where is then the result of it?

      • FrankAT's avatar
        FrankAT
        Community Champion
        5 years ago

        Hi Frixel 

        does your question belongs to Excel, Power Query or DAX?

         

        With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
        FrankAT (Proud to be a Datanaut)