Calculate with Filters from different columns

[webbj]

So thanks to @DataInsights I've been using the following to calculate the average based on mulitple filters from a single column in a table. However i'm now trying to figure out how to find calculate the average based on two conditions from two columns in the same table shown in second code segment.

Measure =
CALCULATE (
    AVERAGE ( Combined[Response Time (Days)] ),
    Combined[Type]
        IN {
        "CT - Change Request (10)",
        "CT - General Support (5)",
        "CT - New Implementation (10)",
        "CT - Technical Issue/Fault (10)"
    }
)

Here is an example of what I've tried, I've tried others as well however it either displays 'blank' or the code errors.

Measure = 
CALCULATE (
    AVERAGE ( 'CT Combined Extracts'[Response Time (Days)] ),
    'CT Combined Extracts'[Type]
        IN {
        "CT - Technical Issue/Fault (10)"
    },
    'CT Combined Extracts'[Service]
        IN {
        "CT - Case Access"
    }
)

Any help would be much appreciated.

[tamerj1 · Accepted solution]

Hi @webbj 
It should work. What error codes are you getting. Note that this is an "AND" condition between the two conditions so double check the spelling and make sure the two conditions actually intersect.

[webbj]

oops it you were right - there was a double space in the data extract and I had only put one space in. Thankyou!