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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gempar
Frequent Visitor

New measure help for countif equivalent - required to count specific words in column

Hi all, hoping you can help with a new measure which I'm sure is quite simple, but my excel knowledge isn't transferring over to PBi. 

 

I want to count all values equal to "New" in a certain column of my table. 

 

 

What function do I need to use for this formula? 

 

Thank you!

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

Hi @gempar

 

Try

 

=
CALCULATE ( COUNTROWS ( TableName ), TableName[YourColumn] = "New" )

Regards
Zubair

Please try my custom visuals

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

Hi @gempar

 

Try

 

=
CALCULATE ( COUNTROWS ( TableName ), TableName[YourColumn] = "New" )

Regards
Zubair

Please try my custom visuals

Thank you very much!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors