Reply
Frequent Visitor
Posts: 12
Registered: ‎10-30-2016
Accepted Solution

Grand Total of Measures doesn't match with SUM of row values

Hello,

I've created a measure that multiplies Qty by AVG(unit price). But, when I put that measure in a table, the grand total is performing its original function (that is Qty * AVG(unit price)) instead of summarizing the individuals row values.
According with the screenshot below, the total of 'Total Estoque (#)' column is 156.257,81, which is the result of 6.410 * 24,38, instead of 101.352,97, which is the SUM of the row values in this column...
Can anybody help me please?
Tks in advance.

 

issue grand total.png

 

 


Accepted Solutions
Super Contributor
Posts: 3,226
Registered: ‎07-08-2016

Re: Grand Total of Measures doesn't match with SUM of row values

@rbaleche

 

If “Custo Medio” is a measure, please try to create a measure for “Total Estoque” with formula like below.

 

Measure = 
SUMX ( Table1, CALCULATE ( SUM ( Table1[Qtde] ) ) * Custo Medio )

Grand Total of Measures doesn't match with SUM of row values_1.jpg

 

Best Regards,

Herbert

View solution in original post


All Replies
Super Contributor
Posts: 3,226
Registered: ‎07-08-2016

Re: Grand Total of Measures doesn't match with SUM of row values

@rbaleche

 

If “Custo Medio” is a measure, please try to create a measure for “Total Estoque” with formula like below.

 

Measure = 
SUMX ( Table1, CALCULATE ( SUM ( Table1[Qtde] ) ) * Custo Medio )

Grand Total of Measures doesn't match with SUM of row values_1.jpg

 

Best Regards,

Herbert

Frequent Visitor
Posts: 12
Registered: ‎10-30-2016

Re: Grand Total of Measures doesn't match with SUM of row values

@v-haibl-msft

It worked perfectly! Thank you very much!

Regards
Rafael