The syntax for ")" is incorrect in powerBI measures

[Cze-Jhin]

Hi All,

I'm pretty new in the powerBI world, and am stuck with a syntax error, hope you can help me with it.

I would like to achieve the following formula = IFERROR((Grandtotal-Outcome A- Outcome B- Outcome C- Outcome D)/ Grandtotal, 0) via PowerBI. 

However, I keep receiving the "Syntax for ')' is incorrect" error, I have tried to remove some brackets or changed the type of brackets, but it still doesnt work. May I know how to fix the issue?

May refer to the following code sample I am using for DAX in PowerBI.

Test Rate 2 = 
DIVIDE(
    {CALCULATE({CALCULATE(COUNTROWS('Table1'), ALL('Table1'))
                -
                COUNTROWS('Table1'), 
                    FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome A"})
                -
                COUNTROWS('Table1'), 
                    FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome B"})
                -
                COUNTROWS('Table1'), 
                    FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome C"})
                -
                COUNTROWS('Table1'), 
                    FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome D"})})
,
    CALCULATE(COUNTROWS('Table1'), ALL('Table1'))
)

 Thank you, would really appreciate if you could help with it.

@PowerBI 

[Cze-Jhin]

Thank you @Anonymous 

[Anonymous · Accepted solution]

The very start of the formula begins with curly brackets, try replacing them with round ones.

DIVIDE(
    (CALCULATE((CALCULATE(COUNTROWS('Table1'), ALL('Table1'))

[shahdhairya]

Hi Everyone, 

Below is my code in Dax Table and I am getting syntax error. Please help.

Calendar =

Var _cal = CALENDAR(MIN(Date1[Date-1]), MAX(Date1[Date-1]))

Var _result =

ADDCOLUMNS(

    _cal,

    "Year", YEAR([Date]),

    "Month", FORMAT([Date], "mmmm"),

    "MonthNum", MONTH([Date]),

    "Year Month", FORMAT([Date], "yyyy mmm"),

    "Year Month Sort", FORMAT([Date], "yyyymm"),

    "Day of Month", DAY([Date])

)

return

[Anonymous]

All formulas in round brackets and text in curly brackets