custom dax - contains

[nataliesmiy1357]

I am wanting to create a custom measure for this data.  I basically want to say, if EventTypeName contains Bronze... print Bronze, if EvenTypeName contains Silver - print Silver, and if EventTypeName contains Gold, print Gold.

I am not sure how to do this.  Thanks in advance,

[themistoklis · Accepted solution]

@nataliesmiy1357 

There are 2 ways using DAX:

You should create a New Column not Measure

New Column =
SWITCH( TRUE(),
SEARCH( "Bronze", Table[EventTypename],,0) <> 0 , "Bronze",
SEARCH( "Silver ", Table[EventTypename],,0) <> 0 , "Silver ",

SEARCH( "Gold ", Table[EventTypename],,0) <> 0 , "Gold",
"Other"
)

OR 

New Column = =IF (CONTAINS(Table[EventTypename],"Bronze"),"Bronze",IF (CONTAINS(Table[EventTypename],"Silver "),"Silver ",IF (CONTAINS(Table[EventTypename],"Gold"),"Gold")))