Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jason2500
Helper I
Helper I

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

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

 

1 ACCEPTED SOLUTION

@Jason2500 ,

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

 

Hope, this is what you need

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

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

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

@Jason2500 ,

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

 

Hope, this is what you need

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? 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.