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
Anonymous
Not applicable

Count rows that match a certain string from a column

Hi,

 

I want to count rows that contain a certain value from a long string in a column

 

Table

 

id   meta

1    apples_abc_def

2    mangoes_abc_def

 

Count rows where meta contains apples

 

How do I write this is dax? I tried search function but it did not work. 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

=calculate (countrows(tablename), search("apples", tablename[meta],, 0)>0)

Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

=calculate (countrows(tablename), search("apples", tablename[meta],, 0)>0)

Regards
Zubair

Please try my custom visuals

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.