I have Product ID data and on the basis of that I want to check which zone has highest sales in current month with the distinct count of product ID. I already have how to check MTD /Count(Distinct {<Year={'$(=Year(Today()))'}, Month={'$(=Month(Today()))'}>} ProductID) but not able to add max sales of zone in current month.
Just a small clarification on my end. If you want to get the highest performer by the KPI of Count(Distinct ProductID), it sounds to me like you are looking for the Zone with highest variety, not the highest sales. I don't recommend using 'Distinct' to evaluate actual sales.
Getting the name of the Zone by a KPI can happen using
Actually product ID number indicates one sale of a product and ID's have some duplicate value those we don't need. We have multiple zones so on that basis of distinct count on product ID I want to calculate the best performing zone saling product. I hope it clears.
