Forum Discussion
gbarr12345
Post Prodigy
Post ProdigyQuery 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])
danextian
Super User
Super UserAlso, do as ray_aramburo suggested. I dont see a need to use SUMX when you're simply summing the whole column.
gbarr12345Post Prodigy
Post ProdigyPerfect thank you. Will do.