Summarize and remove top employee

[stribor45]

I have this DAX code as a measure but having some trouble with it. 

1. I am summarizing the table
2. Ordering in decreasing order
3. Keeping first row (top employee)

The returned table contains this data

Agent	Calls
John	5132

How do I get the name "John" to be returned in my measure above.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

Top calls agent: = 
CONCATENATEX(
		TOPN(
			1,
			ADDCOLUMNS(
				SUMMARIZE(
					'Data',
					'Agent'[Agent]
				),
				"@callstotal", CALCULATE(SUM('Data'[Calls]))
			),
			[@callstotal],
			DESC
		),
		'Agent'[Agent],
		", "
	)