Calculated column or measure for a text value

[Anonymous]

Hey community!

I am looking to create a calculated column or measure based on finding a specific text within an entire text column.

Below is what I am trying to do (writing out/explaining and not writing the DAX here):

Category =
if title CONTAINS "Tik Tok" the the calculated column cell value = "Tik Tok",
if title CONTAINS "YouTube" the the calculated column cell value = YouTube,
for other title = "Others"

I tried out this method, but cannot figure out how to display 'Others' for the rest of the row values

Category =
SWITCH(
true (),
ISERROR( FIND( "Tik Tok", 'Video Stats'[Video Title] ) ) <> TRUE(),"TikTok",
ISERROR( FIND( "Facebook", 'Video Stats'[Video Title] ) ) <> TRUE(),"Facebook",
ISERROR( FIND( "Instagram", 'Video Stats'[Video Title] ) ) <> TRUE(),"Instagram",
ISERROR( FIND( "Zoom", 'Video Stats'[Video Title] ) ) <> TRUE(),"Zoom",
ISERROR( FIND( "Waze", 'Video Stats'[Video Title] ) ) <> TRUE(),"Waze",

[PaulPalma · Accepted solution]

@Anonymous 

I recommend reviewing the DAX Guide: SWITCH – DAX Guide

Based on your example you should try something like this:

Category =
SWITCH (
    TRUE (),
    ISERROR ( FIND ( "Tik Tok", 'Video Stats'[Video Title] ) ) <> TRUE (), "TikTok",
    ISERROR ( FIND ( "Facebook", 'Video Stats'[Video Title] ) ) <> TRUE (), "Facebook",
    ISERROR ( FIND ( "Instagram", 'Video Stats'[Video Title] ) ) <> TRUE (), "Instagram",
    ISERROR ( FIND ( "Zoom", 'Video Stats'[Video Title] ) ) <> TRUE (), "Zoom",
    ISERROR ( FIND ( "Waze", 'Video Stats'[Video Title] ) ) <> TRUE (), "Waze",
    "Other"
)

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

Category =
SWITCH(
true (),
ISERROR( FIND( "Tik Tok", 'Video Stats'[Video Title] ) ) <> TRUE(),"TikTok",
ISERROR( FIND( "Facebook", 'Video Stats'[Video Title] ) ) <> TRUE(),"Facebook",
ISERROR( FIND( "Instagram", 'Video Stats'[Video Title] ) ) <> TRUE(),"Instagram",
ISERROR( FIND( "Zoom", 'Video Stats'[Video Title] ) ) <> TRUE(),"Zoom",
ISERROR( FIND( "Waze", 'Video Stats'[Video Title] ) ) <> TRUE(),"Waze",
"Other"
)

or

Category =
SWITCH(
true (),
not ISERROR( FIND( "Tik Tok", 'Video Stats'[Video Title] ) ) ,"TikTok",
not ISERROR( FIND( "Facebook", 'Video Stats'[Video Title] ) ) ,"Facebook",
not ISERROR( FIND( "Instagram", 'Video Stats'[Video Title] ) ) ,"Instagram",
not ISERROR( FIND( "Zoom", 'Video Stats'[Video Title] ) ) ,"Zoom",
not ISERROR( FIND( "Waze", 'Video Stats'[Video Title] ) ) ,"Waze",
"Other"
)

Refer my Video for : https://youtu.be/gelJWktlR80

[PaulPalma · Accepted solution]

@Anonymous 

I recommend reviewing the DAX Guide: SWITCH – DAX Guide

Based on your example you should try something like this:

Category =
SWITCH (
    TRUE (),
    ISERROR ( FIND ( "Tik Tok", 'Video Stats'[Video Title] ) ) <> TRUE (), "TikTok",
    ISERROR ( FIND ( "Facebook", 'Video Stats'[Video Title] ) ) <> TRUE (), "Facebook",
    ISERROR ( FIND ( "Instagram", 'Video Stats'[Video Title] ) ) <> TRUE (), "Instagram",
    ISERROR ( FIND ( "Zoom", 'Video Stats'[Video Title] ) ) <> TRUE (), "Zoom",
    ISERROR ( FIND ( "Waze", 'Video Stats'[Video Title] ) ) <> TRUE (), "Waze",
    "Other"
)