CODEWITHSUNDEEP
powerpivotpowerview
Chester Lim
Chester Lim

Reputation: 519

What is the equivalent of Excel's Subtotal in Power Pivot?

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.

Upvotes: 0

Views: 166

Answers (1)

WimV
WimV

Reputation: 1005

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

Myformula:=Countrows(mytable)

Upvotes: 0

Related Questions