Forum Discussion
SWITCH or IF
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 =S...
- 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])
