Count by type and concatenate results

[fpennisi17]

Suppose to have a table like this:

Store, Fruit

A, Apple

A, Banana

A, Banana

A, Grape

B, Banana

B, Grape

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 · Accepted solution]

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]

Exactly what I needed!

I'll mark it as solution.

Thank you so much.

[Greg_Deckler]

Great! 🙂