Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
@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
Hi Ivyhai
This blogpost might help you
http://www.powerpivotpro.com/2011/04/the-friendly-neighborhood-operators-and/
br
Erik
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |