How to show values only if it contains 2 names and disregard those with only 1 name

[Anonymous]

Hi everyone,

I need a way to only show rows which have First and Middle Name. 

For e.g.

Mary Jane

Mark

Bob John

The result will only be:

Mary Jane 

Bob John

I am trying to use the contains function ...

Middle Name = IF(CONTAINS('Table','Table'[First and Middle Name]," "), SUM(FTEandContractor[First and Middle Name]),BLANK())

I get the error that the function Sum cannot work with values of type String. How can I achieve this?

[camargos88 · Accepted solution]

Hi @Anonymous ,

Create this measure:

Measure =

VAR _name = SELECTEDVALUE('Table'[name])

RETURN IF(SEARCH(" ", _name, 1, -1) > 0, 1, 0)

and filter the visual:

Remember to apply a trim function to this column.