topic Re: SWITCH or IF in DAX Commands and Tips

SWITCH or IF

vedhikha — Fri, 27 Oct 2023 16:21:42 GMT

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]

)

Re: SWITCH or IF

Dangar332 — Fri, 27 Oct 2023 17:55:27 GMT

hi, vedhikha

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

Re: SWITCH or IF

vedhikha — Fri, 27 Oct 2023 18:43:22 GMT

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])

Re: SWITCH or IF

Dangar332 — Fri, 27 Oct 2023 19:23:10 GMT

Hi, vedhikha

it's difficult to figure out

please provide some sample data with removing confidential information.