topic Re: Count by type and concatenate results in DAX Commands and Tips

Count by type and concatenate results

fpennisi17 — Thu, 23 Apr 2020 13:08:21 GMT

Suppose to have a table like this:

Store, Fruit

A, Apple

A, Banana

A, Grape

B, Banana

B, Grape

How can you get the following output?

Store, Fruits

A, 1 Apple / 2 Banana / 1 Grape

B, 1 Banana / 2 Grape

Greg_Deckler — Thu, 23 Apr 2020 13:19:40 GMT

Well, put Store in a table visualization along with something like:

Measure = VAR __Table = SUMMARIZE( 'Table', [Fruit], "Count",COUNTROWS('Table') ) RETURN CONCATENATEX(__Table,[Count] & " " & [Fruit]," / ")

fpennisi17 — Thu, 23 Apr 2020 13:24:46 GMT

Exactly what I needed!

I'll mark it as solution.

Thank you so much.

Greg_Deckler — Thu, 23 Apr 2020 13:28:44 GMT

Great! 🙂