DAX automatically adding unnecessary parentheses and won't execute code.

[jsmith476]

Hi,

I'm adding a calculated column to get a subtotal percentage off of another calculated column, using ALLEXCEPT to avoid circular dependencies. See code here:

It keeps adding four unnecessary parentheses at the end and giving me an error code because of it. If I delete them and press enter, it goes back to the above. If I add four extra open parentheses at the beginning, it adds another four unnecessary ones at the end.

Does anyone know how to resolve this?

Thanks

[AlexisOlson]

I think it's confused because you're missing a closing bracket "]", so it's interpreting some of those parentheses as part of a column name.

What are the ".[Fund]" and ".[AsOfDate" suffixes there for?