Calculated Measure Returns Incorrect Results

[Anonymous]

Hi,

I am trying to calculate a gross profit based on sales and COGS.

I have two measures: [total sales] and [total cost of sales and services].

I created a measure: 

Gross Profits = [Total Sales]-[Total Cost Of Sales and Services]

But it returns incorrect results:

e.g, the first line should be (320091-218214=101877) and not 1733810.

Can you please help?

thank you!

Maya

[Anonymous]

Total sales was 

Total Sales = sum(Sales[Sales ($K)])

Cost of sales and services was this column (cost of sales alllocated by product):

Cost Of Sales and Services =

Sales[AllocationRate]*CALCULATE(sum(lvl2_Expenses[Cost of sales and services]))

and then this measure:

Total Cost Of Sales and Services = sum(Sales[Cost Of Sales and Services])

Cost of sales total seems correct when I display it- but the measure would not work.

Unfortunately, the data is sensitive so I cannot send it....

[amitchandak]

@Anonymous , I see this as a problem, multiplication should happen at line level or you should force a level

assuming AllocationRate is also a measure

on a common dimension

sumx(Values(Dim[Dim]),[AllocationRate]*CALCULATE(sum(lvl2_Expenses[Cost of sales and services])))

[Anonymous]

Hi Amit,

AllocationRate is a column. would that syntax still work?

[amitchandak]

@Anonymous , seem strange, can share calculations for   [Total Sales]-[Total Cost Of Sales and Services].

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.