Forum Discussion
Count Columns In A Record That Contain Specific Text
Can you share a sample of your data?
My first response is to use the COUNTROWS for the table and wrap it in calculate to filter. Something like:
CALCULATE(
COUNTROWS('Fact'),
FILTER('Fact', [Pass/Fail] ="Pass")
)
You would need to do separate ones for each of the three criteria with that method but without knowing more about your data, that is the best I can come up with off the cuff.
kcantor I agreewith you Anonymous needs to provide a sample of what the data looks like
I keep reading his question though and the way he keeps saying Count COLUMNS
I think he want to check and count across ALL Columns on each ROW - Not Count within a single COLUMN
In either case we need a sample of what the data looks like
EDIT: I guess I was replying while he was sending
Sean Correct. I want a column count where the string is specific. I care nothing for the row count. :smileyhappy: And preferably irregardless of the column name.