Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |