Please Help - Divide Monthly Count of customers that spend, by total Customer Base value

[ClaireBear]

Hi,  

I am trying to calculate the total number of registered customers (Measure - Total Base) and divide this value by the customers that purchase monthy (Measure - Customers that Spent) on a clustered colunn chart. The customer registration table will keep growing as customers sign up!

So if i have 50 000 customers that registered overall in the customer registration table, i want to divide this 50 000 by the count of customers that spend monthly to get a % . 

For example, of 50 000 customers, 3% are buying in January and 2% in February. 

With my calculations, my 50 000 gets broken down by month which is not what i want, im looking to use the total customer base count to do my calculation each month.  

Total Base = Count(Customer registration table[id])
Customers that Spent = DistinctCount(Sales Table[customerid])

Example 

[Payeras_BI · Accepted solution]

Hi @ClaireBear ,

Total Base =
CALCULATE ( COUNT ( 'Customer registration table'[id] ), ALL () )