Print the column values multiple times using DAX

// Assumption is that you've got a table T
// where the structure is more or less this:
// Key	|	Column
// ----------------
// 1	|	ABC
// 1	| 	ABC
// 2	|	XYZ
// 2	|	XYZ
// 2	|	XYZ
// ...
// From your sample it looks like a key
// can only have one distinct value in
// the Column column.

[Output] =
IF( 
	// make sure that only one Key is
	// visible in the current context
	// and it's filtered directly.
	HASONEFILTER( T[Key] ),

	// The below will only work correctly
	// if the assumption above is in force.
	// Otherwise, SELECTEDVALUE will return
	// BLANK() and you'll end up with a string
	// of delimiters only or just an empty
	// string.
	var __numOfVals = COUNTROWS( T )
	var __columnVal = SELECTEDVALUE( T[Column] )
	var __ouput =
		CONCATENATEX(
			GENERATESERIES(1, __numOfVals, 1),
			__columnVal,
			":|"
		)
	return
		__output
)

And, of course, [Output] is a MEASURE, not a calc column.

Best

D

Anonymous , Can you explain the logic of output, not able to connect.