Count the occurrence of values (Text) in a column

[anoop_ellickal]

I have a column like this 

mango

orange

mango

grape

orange

mango

orange

mango

apple

need an out put like 

mange 4

orange  3

Grape  1

Apple 1

[quentin_vigne]

Hi @anoop_ellickal

Add a multiple card box with your fruit column.

It will display every distinct fruit name

Then create a new measure : 

Mesure_CountGlobal = COUNTROWS(YourTable[Fruit])

Add this measure to your multiple card box.

And now you have a count for each value !

- Quentin

[anoop_ellickal]

Thanks you for your support 

I can only add table not the fields 

COUNTROWS(YourTable)

 this is the problem I am facing 

[v-chuncz-msft · Accepted solution]

@anoop_ellickal,

Just drag the column and measure above to Values field of a Table visual.