Wrong total in the table

[Easley08]

Hi 

is there a way to get the right total for this 

measure : 

A = AVERAGE(Table1[COMP_PRICE])

B = SUM(Tabl1[COMP_QTY])

total sum for A*B should be 5560 

thanks

[DataNinja777]

Hi @Easley08,

Did you mean Table1 and Tabl1 in your question to be different tables, or are they supposed to be the same table?  

Assuming that you meant them to be in the same table (i.e., both 'Table1'), the following dax formula will get you the result you need which adds up rows correctly.