Reply
jimrosser
Helper II
Helper II
Partially syndicated - Outbound

Multiply each entry prior to Sum

I have a Table that lists Engine parts that roll up to the Engine number.  

So my table only lists the engine numbers and you can drill down to see the parts.  

My hope is that I can get a cost per lb for each motor from the table.  It would have to multiply the individual qty times the cost per lb.  Instead the table is multiplying the sum of quanity and sum of total cost per lb.   I would like for it to do the calculation at the dropdown level and then sum.

1 ACCEPTED SOLUTION
Syk
Super User
Super User

Syndicated - Outbound

It sounds like you would need to use the SUMX dax function. Without knowing what your data looks like its hard to give an example based on it.

https://learn.microsoft.com/en-us/dax/sumx-function-dax

View solution in original post

2 REPLIES 2
Syk
Super User
Super User

Syndicated - Outbound

It sounds like you would need to use the SUMX dax function. Without knowing what your data looks like its hard to give an example based on it.

https://learn.microsoft.com/en-us/dax/sumx-function-dax

Syndicated - Outbound

Thank you!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)