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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Revilo
Regular Visitor

Column with data separated with semicolon

Hi,

 

Just want to ask, I have a column in one of my table with format shown below. Is this an array? I am interested in counting rows with blank specific string within that array.

 

Ex. 

I am interested only with "followups", if its not present then I will count that specific record with no string of "followups".

 

Revilo_0-1676527898431.png

 

 

3 REPLIES 3
tamerj1
Super User
Super User

Hi @Revilo 
I hope it is as simple as it is described by the given example. Please let me know if it is not. For now please try

=
COUNTROWS (
    FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[Equipment], "followups" ) )
)

=
COUNTROWS (
    FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[Equipment], "followups","appliances", "clothing" ) )
)

can i add more strings in that parameter like the shown above? thanks

wdx223_Daniel
Super User
Super User

=COUNTROWS(FILTER(TABLE,SUMX(Array,FIND(TABLE[Equipment],Array[Col],,0))=0))

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Kudoed Authors