SWITCH or IF

[vedhikha]

I need to write a dax that checks if the column Tenders ="self Tenders" then use "Measure 1" else use "Measure 2". When i use the below the screen blacks out and says "Unexpected Error"

SCORE =SWITCH(

    TRUE(),

    CONTAINSSTRING(Carrier[Tenders], "Self Tenders" ), [Overall Score 2],

    [Overall Score]

   )

[Dangar332]

hi, @vedhikha 

 [Overall Score 2], [Overall Score] can you provide code of these measure?

[vedhikha]

Overall Score = [OTD_SCORE]+[OTP_SCORE]+ SUM(Sheet1[TA_SCORE]) + Claims[Claims_Score]+DASH_OPEN_DISPUTES[Disputes_score]+ SUM('Competitive Pricing'[Rate_score]) + SUM('smartway_partner_list (2)'[Smartway_score])

Overall Score 2 = [OTD_SCORE]+[OTD_SCORE]+ SUM(Sheet1[TA_SCORE]) + Claims[Claims_Score]+DASH_OPEN_DISPUTES[Disputes_score]+ SUM('Competitive Pricing'[Rate_score]) + SUM('smartway_partner_list (2)'[Smartway_score])

[Dangar332]

Hi, @vedhikha 

it's difficult to figure out 

please provide some sample data with removing confidential information.