topic Re: Extra parenthesis added after saving file in DAX Commands and Tips

Extra parenthesis added after saving file

Artefact — Tue, 30 Jul 2024 06:07:05 GMT

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)

Re: Extra parenthesis added after saving file

bhanu_gautam — Tue, 30 Jul 2024 06:53:08 GMT

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

Re: Extra parenthesis added after saving file

artefarct — Tue, 30 Jul 2024 07:53:39 GMT

Hello Bhanu,

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