Ok Here is the ER Diagram for my case
This ER is common everywhere the customer table Have relationship (1:m) with Orders(e.g.: Sales) table.
Here is an example of the Entry Of Orders table:
As you see some customers accept from the store to keep saving their Information (foreign key will be entered in the customer_hid column inside the orders table for membership) , If you found records are Null means the customer has no reference registry in the store it means they (customers) don’t accept to keep their information in the store (they don’t want a membership), this is the whole story which is common everywhere.
The customer churn works successfully with me but the problem is the Total Sales measure calculating only the sales with customers who have the membership based on the membership domain, but I need to compare the sales of non-members with the ones who have a membership dynamically. This problem happened particularly with Visuals need comparisons between the two domains (with/without membership) e.g. Stacked column bar:
The measures I use for new(lost) customer is exactly 100% the same as what you did but only the naming is a deference. All What I need is the (Total Sales) measure doing adaptation between the 2 domains of customers with/without membership.
Is the case example have enough information Sam?