topic Re: Query on a calculation measure in DAX Commands and Tips

Query on a calculation measure

gbarr12345 — Tue, 25 Jun 2024 22:02:17 GMT

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.

Re: Query on a calculation measure

ray_aramburo — Tue, 25 Jun 2024 22:24:05 GMT

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])

Re: Query on a calculation measure

gbarr12345 — Tue, 25 Jun 2024 22:44:59 GMT

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

All sorted now thank you,

Thanks for your response!

Re: Query on a calculation measure

danextian — Tue, 25 Jun 2024 23:18:35 GMT

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

Re: Query on a calculation measure

gbarr12345 — Tue, 25 Jun 2024 23:23:33 GMT

Perfect thank you. Will do.

Re: Query on a calculation measure

Anonymous — Wed, 26 Jun 2024 02:14:36 GMT

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

Re: Query on a calculation measure

gbarr12345 — Wed, 26 Jun 2024 02:18:03 GMT

Yeah the problem is solved now thanks.

I've accepted it as a solution now.

Thank you.