I have a Measure which shows me the top salesman of a customer. This works very well in a visualization. I would like to calculate this now in a calculated column and there is only one salesperson for all customers. Does anyone have an idea how I can set the context in the calculated column correctly?
My Measure is main-sales-people = MAXX(TOPN(1; SUMMARIZE('Customer Sales';'Customer Sales'[Sales People];"main sales people"; [Total Days Transactions]); [main sales people]); 'Customer Sales'[Sales People])
I need the context for each customer