Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
19 | |
13 | |
10 | |
9 | |
8 |
User | Count |
---|---|
15 | |
13 | |
12 | |
11 | |
11 |