Counting by grouping

Hi ezolezzi92 ,

You can create 2 measures

Departments = CONCATENATEX(FILTER(ALL('Table'), 'Table'[ID] = MAX('Table'[ID])),'Table'[Department],",")

Count of ID = COUNT('Table'[ID])

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Departments] =
// HASONEFILTER makes sure that you have put
// a filter on ID and only one ID is visible
// in the current context. You can also use
// HASONEVALUE but this one only makes sure
// that one value of ID is visible in the current
// context, be it through an explicit filter
// or cross-filtering.
IF( HASONEFILTER( T[ID] ),

	var __depts = VALUES( T[Department] )
	var __deptCount = COUNTROWS( __depts )
	var __output =
		if( __deptCount > 0,
			__deptCount & " (" &
			& CONCATENATEX(
				__depts,
				T[Department],
				",",
				T[Department],
				ASC)
			& ")"
		)
	return
		__output
)

Best

D