how to count columns contain multiple specific values.

[Anonymous]

I've created a new column below, it works.  but how can add 1 more values, say i want count both those with vaule "Direct Mail" and "Mail" or can i use contain, say contain "Mail"

Working:  

DM Count gifts = countax(filter('table','table'[Response Channel]="Direct Mail"),'table'[Response Channel])

thanks.

[v-haibl-msft · Accepted solution]

@Anonymous

If you have a column which similar with below one, you can create a measure to get the number of items which contain "Direct Mail" or "Mail".

Measure = 
CALCULATE (
    COUNTROWS ( 'table' ),
    SEARCH ( "Direct Mail", 'table'[Response Channel],, 0 ) > 0
        || SEARCH ( "Mail", 'table'[Response Channel],, 0 ) > 0
)

Best Regards,

Herbert

[donsvensen]

Hi Ivyhai

This blogpost might help you

http://www.powerpivotpro.com/2011/04/the-friendly-neighborhood-operators-and/

br

Erik