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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mattbstrong
Helper IV
Helper IV

COUNTROW with a Containing a Letter in a Word

VAR Blank_ID = CALCULATE(
COUNTROWS(D_Eng_Win),
ISBLANK(D_Eng_Win[atl_workfrontrefid]) = TRUE()
)
 
What if I want to count rows like I did above but instead of looking for blank I want to count any word that contains the letter N?
Can I make it case sensative?
1 ACCEPTED SOLUTION
themistoklis
Community Champion
Community Champion

@mattbstrong 

 

Tr the following formula:

MEASURE FindN =
    CALCULATE (
        COUNTROWS ( D_Eng_Win ),
        FILTER (
            D_Eng_Win,
            SEARCH ( "N", D_Eng_Win[atl_workfrontrefid],, 0 ) <> 0
                || SEARCH ( "n", D_Eng_Win[atl_workfrontrefid],, 0 ) <> 0
        )
    )

View solution in original post

1 REPLY 1
themistoklis
Community Champion
Community Champion

@mattbstrong 

 

Tr the following formula:

MEASURE FindN =
    CALCULATE (
        COUNTROWS ( D_Eng_Win ),
        FILTER (
            D_Eng_Win,
            SEARCH ( "N", D_Eng_Win[atl_workfrontrefid],, 0 ) <> 0
                || SEARCH ( "n", D_Eng_Win[atl_workfrontrefid],, 0 ) <> 0
        )
    )

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.