0

Is there a way to count the total number of rows returned in a filtered table in Power Pivot? I tried populating a column with 1 or 0 and used SUM. But it returned the number of rows in the original table and not in the filtered.

Chester Lim
  • 459
  • 7
  • 19

1 Answers1

0

if you want to count rows, you can use this formula 

Myformula:=Countrows(mytable)
WimV
  • 1,005
  • 6
  • 11
  • Hello, i would like to count the rows that are visible with my current filter. Countrows(mytable) returns all the rows including those that are filtered. – Chester Lim May 03 '16 at 16:52
  • Have you add this formula as a calculated column or as measure? Can you upload the excel file? – WimV May 03 '16 at 20:20
  • I made a new post that has an image uploaded. Sorry I can't upload the file because it is confidential. Please take a look at this post. http://stackoverflow.com/questions/37011091/is-there-a-way-to-populate-a-column-with-scalar-value-in-power-pivot Thank you for your time. – Chester Lim May 03 '16 at 21:07