Greetings from Rhodes, Greece !
Here’s a very complex DAX problem our team has been facing the previous days.
The main problem is how can we show aggregated results and distinct counts on customer per salesman (which is quite ok, but also by product code (ProductSK) ignoring the product dimension on our pivot table for the denominator on the percentage)
The desired percentage (fraction) to show on the Salesman and Product level is the following :
Distinct count of customers per salesman that have best seller product purchases (product - salesman level) / Distinct count of total customers per salesman with over 500 euro net sales (ignoring the product level on the matrix table)
Thanks a lot.
Kind Regards,
ConG