')' expected, but all () statements are closed

[Anonymous]

Hello,

I am getting an error in Power BI Report Builder that I am positive I should not be getting. I'll let it speak for itself.

Here is the error message:

But here is the formula for "DataBar2":

Can you see the problem?

All four sets of parentheses have an opening and closing parenthesis, but the error message says that it expects a closing parenthesis somewhere.

My question is, where does it expect the closing parenthesis, and why?

Please ensure you have thoroughly read the question and passed a Captcha before responding. I don't want another extremely unhelpful response from a bot.

EDIT: Here is some context:

The "Percent" in the formula refers to a dataset I have named Percent. The deductible value was taken from the same cube in both my main and Percent datasets, but the percent dataset aggregates by State and Year fields while the main one also aggregates by City. The above formula is used for the City level databar.

The goal is to have a report that separates the data by state and city, with the parameter being Year. I figured that by creating a new dataset that gives the deductible by year and state, I could get subtotals for each state within each year.

Here's a sample of the report in design view:

And here's a picture of what the report currently looks like without the databar:

The far right column is supposed to show the total by state or city and year. 99,669.71 is the grand total, but 4100 is the total for the year 2005. 4100 is shown at the bottom as a total column, as shown here:

[d_gosbell · Accepted solution]

So if the "Percent" is meant to refer to a dataset then it's in the wrong spot. I'm guessing that you want the denominator of your divide operation to come from this dataset, if that is the case then you need to move the closing bracket for your SUM function.

In your expression, the SUM function has been closed already and it is expecting another closing bracket to close the one at the start of the SUM call. 

[d_gosbell]

It's probably the extra , "Percent" you have in the formula. I can't see what that is supposed to relate to, but it does not look like a valid expression with that in there.

[Anonymous]

I appreciate your help. See the edit for more details on the project.