Forum Discussion
Count Columns In A Record That Contain Specific Text
Honestly, if the rows all have seperate Id numbers, I would sum the "pass' scenario then add across for the total. I say that because I would, later, want to calculate the ratios as they pertain to each individual inspection. You would need to use the row ids in the table however but could only display the final measure, not all of the intermediary ones.
Pass Inspection1 = CALCULATE(SUM(COUNTROWS), [Inspection1]="pass") Same for other columns. then add the measures for a third measure.
Number of Pass = [Pass Inspection 1]+[Pass Inspection2]+[Pass Inspection3]
that would leave room to use each individual measuer to be used in other ways.
Is there a reason for wanting to calculate only for three complete inspections?
There's actually about 30+ inspections being logged for the day across 12 nationwide locations by 24 different people. I had been trying your method for awhile today but I kept getting circular reference errors. But for some reason it's all working now. I was trying to avoid this method if I could because of the amount of helper columns needed and the fact that the inspections can and will as needs change.
The report view will display various metrics on common inspection failures, failures associated with locations, equipment, etc.
But if there's not a method to just count across the row then I guess it is what it is.
This was a very simple snippet of the data. I really just needed to figure out how to get the count number so I could do, % scores, averages, etc. And now that the brute force method seems to be working now I think I can get things rolling again. Sorry if I over simplified before.
And.... it looks like I type too slow. :)