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)

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)

    • Frixel's avatar
      Frixel
      Post Prodigy
      5 years ago

      FrankAT 

       

      I have a query in powerbi and in the visual a table.

      i want to know how many rows there are in the query 

      • FrankAT's avatar
        FrankAT
        Community Champion
        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)