Forum Discussion
Solved
Row level Totals - Miscalculation
Hi,
I am trying to calculate the total price as shown below.
DAX measure i am using is = sum(quantity) * sum(price)
Instead of caluclating this way : (10 *4) + (20*5) + (30*6)
i am getting total based on this logic: (10+20+30) * (4+5+6)
How to create a measure for this logic
(10 *4) + (20*5) + (30*6)
I only need to show the entire total.
| Category | Name | Quantity | Price | Total | |
| Fruits | Apple | 10 | 4 | 40 | |
| Fruits | orange | 20 | 5 | 100 | |
| Fruits | banana | 30 | 6 | 180 | |
| 320 | Expected Outcome | ||||
| 60 | 15 | 900 | This is outcome i am getting in Power BI |
Hi Sandhya877
to force summing the visible values
Measure =
SUMX (
SUMMARIZE ( 'Table', [Category], [Name] ),
CALCULATE ( SUM ( [Quantity] ) * SUM ( [Price] ) )
)
3 Replies
Hi Sandhya877
to force summing the visible values
Measure =
SUMX (
SUMMARIZE ( 'Table', [Category], [Name] ),
CALCULATE ( SUM ( [Quantity] ) * SUM ( [Price] ) )
)Thank you. It worked.
