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 gettin...
Hi Sandhya877
to force summing the visible values
Measure =
SUMX (
SUMMARIZE ( 'Table', [Category], [Name] ),
CALCULATE ( SUM ( [Quantity] ) * SUM ( [Price] ) )
)
tamerj1
Community Champion
Community ChampionHi Sandhya877
to force summing the visible values
Measure =
SUMX (
SUMMARIZE ( 'Table', [Category], [Name] ),
CALCULATE ( SUM ( [Quantity] ) * SUM ( [Price] ) )
)
Thank you. It worked.