I want to create a graph showing the proportion of new customers versus returning customers per year. In the first year, all the customers will be 'new' and in the other years, there will be some customers returning again (the new sale orders) and some will have a sale order for the first time. I already have a measure called 'Active customers' calculating the total of active customers (so with at least one sale order). I guess I need two more measures for 'New customers' and 'Returning customers'.
Can anyone help me to do this?