cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PetrK
Helper I
Helper I

Measure with IF( CONTAINSSTRING

Hi 😀
Help me please
I want to create Measure like

IF(CONTAINSSTRING( table[text_col] ,"ABC"), TRUE(), FALSE())

This formula as is doesn't work. What is wrong?

1 ACCEPTED SOLUTION
PetrK
Helper I
Helper I

In meantime I found solution

 
SUMX(
       FILTER(
            table,
            CONTAINSSTRING(table'[string_col], "ABC")),
        1)


It come from this page 

View solution in original post

5 REPLIES 5
PetrK
Helper I
Helper I

In meantime I found solution

 
SUMX(
       FILTER(
            table,
            CONTAINSSTRING(table'[string_col], "ABC")),
        1)


It come from this page 

JorgePinho
Solution Sage
Solution Sage

What error are you getting? Are you creating a measure or a column?

Hi, I want to create Measure. this formula works in Column but in Measure it return error

 

"A single value for column 'table'[text_col] cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

 

There is missing some Iterator, but I don't know which one a where it must be placed in code.

 

Since you don't want a calculated column, it is missing an aggregator. I don't know what you pretend to do with the measure. If you're idea is to use it in a table visual then you can do something like this:

IF(CONTAINSSTRING( MAX(table[text_col]) ,"ABC"), TRUE(), FALSE())

 

it doesn't work, it return False for all rows

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.