cancel
Showing results for
Did you mean:
webportal Member

## How to calculate the total of a column in a table

`Valor total = SUM('Códigos e valores'[Valor unitário])*SUM(Csv[Quant.])` This works ok for all the rows of the table except for the grand total at the bottom, because the definition can't be quantity * value.

But how to express this in the correct way?

1 ACCEPTED SOLUTION

Accepted Solutions Super User

## Re: How to calculate the total of a column in a table

Lets play with some context transition ```Valor total =
SUMX(
'Códigos e valores',
CALCULATE(SUM('Csv'[Quant.]))* 'Códigos e valores'[Valor unitário]
)```

Proud to be a Datanaut!

8 REPLIES 8 Super User

## Re: How to calculate the total of a column in a table

Please give this a try

```Valor total =
SUMX(
'Códigos e valores',
'Códigos e valores'[Quant.] * 'Códigos e valores'[Valor unitário]
)```

Proud to be a Datanaut!

webportal Member

## Re: How to calculate the total of a column in a table

Thanks for helping.

The problem here is that the field "Quant" is on a table with many-to-one relationship with another table (Table2).

This Table2 has a relationship of one-to-many to table "Códigos e valores" where field "Valor Unitário" is located.

Therefore, SUMX doesn't work in this scenario, not even with a RELATED in the expression. Super User

## Re: How to calculate the total of a column in a table

So is the Quant. column in a parent, or child table?

Proud to be a Datanaut!

webportal Member

## Re: How to calculate the total of a column in a table

Hi,

"Quant" is on the may side of the relationship, so I think it is a child. Super User

## Re: How to calculate the total of a column in a table

Lets play with some context transition ```Valor total =
SUMX(
'Códigos e valores',
CALCULATE(SUM('Csv'[Quant.]))* 'Códigos e valores'[Valor unitário]
)```

Proud to be a Datanaut!

Highlighted
webportal Member

## Re: How to calculate the total of a column in a table

He he! Not exactly that one... The following worked, so thanks anyway!

`Valor total = SUMX('Códigos e valores';CALCULATE(SUM(Csv[Quant]))*CALCULATE(SUM('Códigos e valores'[Valor unitário])))` Super User

## Re: How to calculate the total of a column in a table

Nice work.  In theory, you shouldn't need the second CALCULATE but hey, if it works and the speed is all good then well done!

Proud to be a Datanaut!

webportal Member

## Re: How to calculate the total of a column in a table

@Phil_Seamark, you're right. No need for a second CALCULATE.

But in your expression, you miss the SUM. So this is perfect:

`Valor total = SUMX('Códigos e valores';CALCULATE(SUM(Csv[Quant]))*SUM('Códigos e valores'[Valor unitário]))`