7. Total of values on a filtered table



 PROBLEM:  How to calculate the number of batches on a filtered table?


=2.SUBTOTAL(1.103;SOURCE[BATCH])
  1.  Counts the number of cells that are not empty in a range;


  2.  Returns a subtotal in SOURCE[BATCH].


    The formula =SUBTOTAL(103;SOURCE[BATCH]) calculates the number of non-empty cells in the column BATCH of the table SOURCE

SUBTOTAL

Subtotal - Syntax

SUBTOTAL(function_num,ref1,[ref2],...)

The result without filtering will be "5".