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 @brianalva 

[brianalva · 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'))

[brianalva]

All formulas in round brackets and text in curly brackets