Measure - if contains A10, B11 etc

[dommyw277]

One of our Databases is really locked down, we cant create columns, only measures.

Is there anyway i can create a measure where it looks at the column called requester.

The column is made up of 3 letters or a name- if it contains just 3 letters can it return say "accounts" otherwise its "something else"?

[cengizhanarslan]

Please try the measure below:

Requester Type =
VAR _Requester = SELECTEDVALUE ( Table1[Requester] )
RETURN
    IF (
        LEN ( _Requester ) = 3,
        "Accounts",
        "Something Else"
    )

But remember since it is a measure and not a column, it cannot be used as a legend, axis, or slicer field directly. But it can still be used as a displayed value in a table visual or as a visual-level filter.

[mickey64 · Accepted solution]

For your reference.

Step 0: I use these data below.

Step 1: I make a measure and table below.

Measure = IF(NOT ISBLANK(MAX('DATA'[requester])) && LEN(MAX('DATA'[requester]))=3, "accounts", "something else")

[krishnakanth240]

Hi @dommyw277 

Yes, we can handle it using a measure even without creating a column in Power BI. Can you try this measure

Requester Type =

VAR Req = SELECTEDVALUE('Table'[requester])

RETURN

IF(NOT ISBLANK(Req) && LEN(Req) = 3, "accounts", "something else")