When I filter a table, I have this formula to tell me how many rows are being displayed as a result of the filtering:
I now need to do something similar for another column, but in this case I am totaling the numbers contained in these cells. As I filter the table, I need this total to take into account the cells that are being filtered out.
How can I achieve this please?
Code:
SUBTOTAL(102,PeriTable[ID])
How can I achieve this please?