Forum Discussion

ezolezzi92's avatar
ezolezzi92
New Member
6 years ago

Counting by grouping

Hi all,   I'm trying to come up with a formula that counts & shows the departments for each of the following IDs: ID Department 101290 A 103458 B 101290 B   For example, I wou...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!