- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-08-2024 03:57 AM | |||
07-22-2024 04:34 PM | |||
06-06-2024 04:39 AM | |||
09-04-2024 01:43 PM | |||
12-03-2024 10:34 AM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |