Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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".
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
=COUNTROWS(FILTER(TABLE,SUMX(Array,FIND(TABLE[Equipment],Array[Col],,0))=0))
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |