How to sum the particular text in the String column using dax measures?

[Jason2500]

Hi

I am having a text column as follow

Text

Apple

Carrot

Apple

Carrot

Beans

Kiwi

Beans

Kiwi

I need to create a separate card for each fruit. How to sum the total number of apple or carrot etc present in the column using dax measures?

I need to create separate DAX measures for each fruit.

Please advise

[amitchandak]

@Jason2500 , Either you can create Measures or try two use multirow KPI

[Jason2500]

Hi @amitchandak  Thanks for your quick reply. Can you please tell me how to create the measure using dax function?

[amitchandak · Accepted solution]

@Jason2500 ,

Apple = countx(filter(Table, Table[Fruit]="Apple"), Table[Fruit])

Hope, this is what you need

[NaifO]

what if I would count String in a column that contains a particular word 

for example, a column contains the full name and I would calculate how many Jeff we have?