Forum Discussion

gbarr12345's avatar
gbarr12345
Post Prodigy
2 years ago
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 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.

Need Help
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

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

6 Replies

  • ray_aramburo's avatar
    ray_aramburo
    Super User
    2 years ago

    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's avatar
      gbarr12345
      Post Prodigy
      2 years ago

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

       

      All sorted now thank you,

       

      Thanks for your response!

      • danextian's avatar
        danextian
        Super User
        2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      gbarr12345
      Post Prodigy
      2 years ago

      Yeah the problem is solved now thanks.

       

      I've accepted it as a solution now.

       

      Thank you.