Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @ClaireBear ,
Total Base =
CALCULATE ( COUNT ( 'Customer registration table'[id] ), ALL () )
Hi @ClaireBear ,
Total Base =
CALCULATE ( COUNT ( 'Customer registration table'[id] ), ALL () )
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |