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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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