GroupBy keeping a column not participating in defining unique combination

[Anonymous]

From a table containing multiple contacts per account and information about telemarketing, i need to produce a status at an account level. The following DAX formula will successfully produce a table of unique accounts and a maximum index per account. But I need to display the status name also, if I add table[status] as a column in GROUPBY, then it would display a combination of accounts and status names, it won't create a list of unique accounts.

Account	contact	status	status index
A	X	abc	1
A	Y	def	2
A	Z	ghi	3
B	X	abc	1
B	Y	def	2
C	X	abc	1

.t_190731_ctasSinCita_abm =
GROUPBY (
    table,
    table[account],
    "max status index", MAXX (
        CURRENTGROUP (),
        table[status index]
    )
)

[Anonymous]

Mate, do you need to create a calculated table out of this? If you do, then do it in Power Query in M, not in DAX. DAX is not a data mashup language. It's a Data Analysis Expressions language.

On the other hand, if you want to have a measure that will return the maximum index for an account, then this will do the job:

[Maximum Index] =
var __oneAccountVisible = HASONEVALUE ( T[Account] )
var __maxIndex = MAX ( T[Index] )
return
	if (
		__oneAccountVisible,
		__maxIndex
	)

And if you want to have a measure that'll return the status for the [Maximum Index], then:

[Maximum Status] =
var __maxIndex = [Maximum Index]
var __maxStatus =
	calculate (
		values ( T[status] ),
		T[status index] = __maxIndex
	)
return
	__maxStatus

Best

D.