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?
Solved! Go to Solution.
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())
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.