The syntax for ')' is incorrect

[Anonymous]

Hello guys. Im trying to do a DAX command and I´m getting the following error.

What I´m trying to do is highlight teams based on their names (whenever I click one team, it will highlight it on a visual).

• The table "Team_Highlight" only has the team names from the "Premier League" table
• The table "Premier League" has information about the different Premier League teams

I will paste the DAX code and the error below: 

TeamToHighlight2 =

var _selectedteam =

VALUES( Teams_Highlight[Team Name] )

var _teamtohighlight =

SELECTEDVALUE( 'Premier League'[Team Name] )

var _filtered =

ISFILTERED( Teams_Highlight[Team Name] )

var _result =

SWITCH(

true,

not( _filtered ), "#0079EB",

_teamtohighlight IN _selectedteam

&& _filtered, "0079EB",

"#99C9F7"

)

Error: The syntax for ')' is incorrect. (DAX(var _selectedteam = VALUES( Teams_Highlight[Team Name] )var _teamtohighlight = SELECTEDVALUE( 'Premier League'[Team Name] )var _filtered = ISFILTERED( Teams_Highlight[Team Name] )var _result = SWITCH( true, not( _filtered ), "#0079EB", _teamtohighlight IN _selectedteam && _filtered, "0079EB", "#99C9F7"))).

Hope it works.

Thank you

[Anonymous]

Thank you a lot for the help. I thought the solution was with the return clause but didn´t know what to return

[daXtreme · Accepted solution]

It is what it is: you've got the syntax wrong. Head over to www.daxformatter.com, paste the code in there and let it check it. It'll show you where the problem is...

Spoiler

TeamToHighlight2 =
VAR _selectedteam =
    VALUES( Teams_Highlight[Team Name] )
VAR _teamtohighlight =
    SELECTEDVALUE( 'Premier League'[Team Name] )
VAR _filtered =
    ISFILTERED( Teams_Highlight[Team Name] )
VAR _result =
    SWITCH(
        TRUE,
        NOT ( _filtered ), "#0079EB",
        _teamtohighlight
            IN _selectedteam
            && _filtered, "0079EB",
        "#99C9F7"
    )
RETURN
    _result