Elizabeth - Without seeing your data its a little confusing what you are asking. Are you wanting to combine the two together into one bar? If so, you could write a new calculation: [New Customers] + [Existing Customers].
If this isn't helpful, can you upload a twbx example?
Thanks, Ashley. My 'new' and 'existing' customers are each sums over a time period so I'm having trouble aggregating these already aggregated measures. Is it possible to do the calc you suggest? Essentially doing a sum of two sums?
Oh, and for some reason my question got posted under my other name, Elizabeth Morrison. We are one in the same. As I say, I'm new to this so not sure why this is happening.
You might need two if then statements in your calculation. Any chance you can upload an example?
Unfortunately, I don't know how without violating confidentiality. Am getting from client better definition of new/existing customers measure calculation to use in an if then statement. May be able to do with true/false filter you showed me in other project. What are the two if then statements you were thinking of?
Not being able to see it my best guess would be to use either:
count(If [Customer type]="New" Or [Customer type]="Existing" then [Customer Name] end)
count(If [New Customer]=True Or [Existing Customer]=True then [Customer Name] end)
If you have multiple data points per customer you can used countd() which counts distinct records, but your data must be extracted to do this.