Count rows if a value in a column starts with a specific word.

[Syndicate_Admin]

Hello

I'm trying to create a Measure that counts only the rows in a table if one of the columns starts with the word "MAIN*".

What I currently have that isn't working is:

[DataInsights · Accepted solution]

@donebroaja,

Try this measure:

Row Count =
CALCULATE ( COUNTROWS ( MyTable ), LEFT ( MyTable[Column], 4 ) = "MAIN" )

[Anonymous · Accepted solution]

Your solution is great, @DataInsights .Here I have another idea in mind, and I would like to share it for reference. 

Hi @Syndicate_Admin

Please try the following dax:

Count Rows with MAIN = CALCULATE(
    COUNTROWS('Table'),
    IFERROR(SEARCH("MAIN", 'Table'[Column1], 1, 0) = 1, FALSE)
)

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DataInsights · Accepted solution]

@donebroaja,

Try this measure:

Row Count =
CALCULATE ( COUNTROWS ( MyTable ), LEFT ( MyTable[Column], 4 ) = "MAIN" )