How to create calculated column that does not change with filters

[Anna Gleboff]

I am trying to insert a column that is essentially the denominator and does not change when I filter the numerator.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I am attaching a table as an example of what i am attempting to do .

 

I would like to insert a calculated column that counts customers by server by month. The issue i am having is that if i allow filtering on the item, that calculatd column will change based on the filter. I DO NOT want that to happen. I need to use the column as a denominator for monthly customers and I would like it to state constant regardless of filtering.