Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION
v-haibl-msft
Employee
Employee

@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
)

how to count columns contain multiple specific values_3.jpg

 

Best Regards,

Herbert

View solution in original post

2 REPLIES 2
v-haibl-msft
Employee
Employee

@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
)

how to count columns contain multiple specific values_3.jpg

 

Best Regards,

Herbert

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.