I have a table with 12 different columns that could be any number between 1 and 5 or could be "null". I want to be able to count the number of fields in each column that are less than 4. I know the following formula doesn't work, but it's basically what I am trying to accomplish.

{L_CODE}{L_COLON} {L_SELECT_ALL_CODE}

`CSATTest = CALCULATE(`

COUNTROWS('CSATRaw'),

FILTER('CSATRaw','CSATRaw'[ResolvedTimely]<4),

Filter('CSATRaw',

'CSATRaw'[ResolvedTimely]<>"null")

)

+

CALCULATE(

COUNTROWS('CSATRaw'),

FILTER('CSATRaw','CSATRaw'[NoDisruption]<4),

Filter('CSATRaw',

'CSATRaw'[NoDisruption]<>"null")

)

...and keep going for all 12 columns.

Thanks,

John