Hi guys, I am trying to calculate the sales of my customers who are greater than the 95th percentile of all customers within each segment. The total is correct, but I want the measure to calculate the unique/distinct customers who attribute towards that top percentile sales volume. As you can see, each customer has a blank value despite the total being accurate. Any ideas of how I can tweak my measures?
Essentially I want the measure to calculate only the customers sales figures from Hill Supplies to Mr. Rooter.