The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
10 | |
7 |