Count rows in table

[Frixel]

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?

[FrankAT]

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]

Hi @FrankAT 

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

[FrankAT]

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]

@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 · Accepted solution]

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)