Help with token error

[Anonymous]

Hi,

I am new to power-bi and am trying to make quite a complex model, could use some help!

I have a sales table with product and business unit data, and an expenses table with a business unit data.

I want to be able to allocate expenses by products based on the rate they constiture of the sales.

My relationships are as follows:

I created a new column in the sales table with the allocation, it works great:

AllocationRate = DIVIDE(

Sales[Sales ($K)],

CALCULATE(SUM(Sales[Sales ($K)]),FILTER(Sales,Sales[Business Unit]=EARLIER(Sales[Business Unit]))))

And now I want to multiply the allocationrate column by the operating income, but it doesnt work.

this is my syntax:

ExpensesAllocation = ('Sales'[AllocationRate])*CALCULATE(SUM('Expenses3[Total Operating Income (Loss)])))))))))

and i get this error:

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 41, 'Expenses3[Total Operating Income (Loss)])))))))))).

what is wrong? the relationships? the syntax? please help!

Thank youu

[Anonymous]

Thank you!

[Anonymous · Accepted solution]

Hi @Anonymous 

Please check the column type of your Total Operating Income (Loss) column. Here you use sum function to calculate it, this column should be in number type.

I have test by a sample model, my dax code works well and it shouldn't be relationship or synatx error.

My sample is as below.

Year :

Expense3:

Sales:

AllocationRate = DIVIDE(
Sales[$K],
CALCULATE(SUM(Sales[$K]),FILTER(Sales,Sales[Business Unit]=EARLIER(Sales[Business Unit]))))

ExpensesAllocation = ('Sales'[AllocationRate])*CALCULATE(SUM('Expenses3'[Total Operating Income (Loss)]))

Relationship:

You see my ExpensesAllocation column works well with the same relationship and show correct result. Please check whether this column is in number type in your model.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.