Row level Totals - Miscalculation

[Sandhya877]

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

[FreemanZ]

hi @Sandhya877 ,

try like:

measure =

SUMX(

data,

data[quantity]*data[price]

)

[tamerj1 · Accepted solution]

Hi @Sandhya877 

to force summing the visible values 

Measure =
SUMX (
SUMMARIZE ( 'Table', [Category], [Name] ),
CALCULATE ( SUM ( [Quantity] ) * SUM ( [Price] ) )
)

[Sandhya877]

Thank you. It worked.