Extra parenthesis added after saving file

[Artefact]

Hi,

Sometimes PBI adds a lot of extra parenthesis at the end of a DAX formula. Till now after copy paste the formula they don't show up again. But now PBI keeps adding them and returns an error on the formula. But only when I save the PBIX! So when applying the formula, it works fine, but after saving the file, PBI returns "hey your forumula has 3 extra parenthesis which don't belong there". 

And trust me , there's noting wrong with the formula, it works fine before saving. The error message shows 2 more parenthesis at the end, which PBI keeps adding when saving. And when I delete the last parenthesis in my formula, PBI just adds one more.

IF (
    OR (
        AND ( AVERAGE ( workorder_time[Age in years] ) > 29, [Total spent time] > 55 ),
        AND ( AVERAGE ( workorder_time[Age in years] ) < 30, [Total spent time] > 50 )
    ),
    "#4287f5"
)

 Result when saving :

IF <same formula>

"#4287f5"  ))) (2 too many)

[artefarct]

Hello Bhanu,

Thank for your quick reply. But I get the same error when saving. Keeps adding extra parenthesis .

[bhanu_gautam]

@Artefact , Try using Variables

VAR AgeAverage = AVERAGE(workorder_time[Age in years])
VAR TotalSpent = [Total spent time]
RETURN
IF (
OR (
AND (AgeAverage > 29, TotalSpent > 55),
AND (AgeAverage < 30, TotalSpent > 50)
),
"#4287f5"
)