Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gbarr12345
Post Patron
Post Patron

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.

 

gbarr12345_0-1719352904813.png

 

 

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.

1 ACCEPTED SOLUTION
ray_aramburo
Super User
Super User

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





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





View solution in original post

6 REPLIES 6
v-jiewu-msft
Community Support
Community Support

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

 

Yeah the problem is solved now thanks.

 

I've accepted it as a solution now.

 

Thank you.

ray_aramburo
Super User
Super User

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





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





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.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Perfect thank you. Will do.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.