Sum of 2 text values within 1 dimension

[Diinkant]

Hi,

I need help please if possible. I am trying to create a measure that is a percentage between how many people are new vs returning customers. 

I have a dimension call [Customer Repeat] and under that I have Yes and No and you can select this as a filter to filter out the data.

How do I create the measure so that it sums up 'No' /  'Yes'? I tried Sum(Customer Repeat  = 'No'), but that data wasn't accurate. Any ideas please or point me in the right direct? 

Thanks

[BrunPierre · Accepted solution]

Sum(Aggr(Count({<"Customer Repeat"={'No'}>} "Customer Repeat"), "Customer Repeat"))

[Diinkant]

Thanks will give that a go.

So to get the percentage would do that Sum(Aggr(Count({<"Customer Repeat"={'No'}>} "Customer Repeat"), "Customer Repeat"))/Sum(Aggr(Count({<"Customer Repeat"={'Yes'}>} "Customer Repeat"), "Customer Repeat")) * 100?

Does this also not calculate duplicates as in someone purchases more than 1 product, it would show as 2 separated lines instead of just 1 but would like it to be calculated as 1.

[Diinkant]

Thanks for this mate, much appreciated. I used Distinct ID after 'No', which took out the duplicates.