Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

how to count columns contain multiple specific values.

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's avatar
    v-haibl-msft
    10 years ago

    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

2 Replies