Query on a calculation measure

[gbarr12345]

Hello,

I have a query on a measure that I wrote.

I'm trying to create a measure that adds up numbers from  2 fields from 2 different tables.

The fields are called '9LE' from the Module Sales with Inventory Table and '9LE' from the Warehouse Data Tasman Table.

I wrote the measure and no error came up but when I pull the measure in, the result is off by a very small number as per my screenshot. The third number doesn't add up to the first 2 numbers combined.

Can anybody see any issues with my measure?

BC & Tas 9LE =

SUMX(

    'Module Sales with Inventory' ,

    'Module Sales with Inventory'[9le]

) +

SUMX(

    'Warehouse Data Tasman',

    'Warehouse Data Tasman'[9LE]

)

Many Thanks in advance.

[v-jiewu-msft]

Hi @gbarr12345 ,

First of all, many thanks to @ray_aramburo @danextian  for very quick and effective replies.

Based on the description, you seem to have solved the problem.

If solving the problem, please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu

[gbarr12345]

Yeah the problem is solved now thanks.

I've accepted it as a solution now.

Thank you.

[ray_aramburo · Accepted solution]

I don't see an issue but check the rounding on both sums. Or change it to BC& Tas 9LE = SUM( 'Module Sales with Inventory'[9le]) + SUM('Warehouse Data Tasman'[9LE])

[gbarr12345]

Ah yes apologies, it seems it was a rounding issue.

All sorted now thank you,

Thanks for your response!

[danextian]

Also, do as @ray_aramburo  suggested. I dont see a need to use SUMX when you're simply summing the whole column.

[gbarr12345]

Perfect thank you. Will do.