Forum Discussion
Solved
Query on a calculation measure
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 Sa...
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])
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])
Ah yes apologies, it seems it was a rounding issue.
All sorted now thank you,
Thanks for your response!
Also, do as ray_aramburo suggested. I dont see a need to use SUMX when you're simply summing the whole column.
Perfect thank you. Will do.
