Total for a calculated column

[Syndicate_Admin]

Good afternoon

I have a column whose data comes from a quick measure. The total for that column is incorrect because it must be the sum of all values and not the calculation.

How can I make it add me the total of the calculated values with the following function:

PTSTOCK x Surface PT = [PTSTOCK] * [PT Surface].

Thank you so much for your help!

Gears

[Anonymous]

Hi @Syndicate_Admin ,

The total for measure is not simply the sum of value, it's a calculated value by the formula too.

It's better to share some sample data and the formula you are using to us.

Best Regards,

Jay

[amitchandak]

@Syndicate_Admin , if these are measures you can not create a column on top of it

you can have like

PTSTOCK x Surface PT =

sumx(Table,  [PTSTOCK] * [PT Surface] )

if both on them are measure

sumx(Values(Table[Groupby]),  [PTSTOCK] * [PT Surface] )

where Groupby is column / unsummarized column in visual

[Syndicate_Admin]

Hi @Syndicate_Admin

I am not working with your solutions since both components of the formula are calculated measures.

I have no way to calculate the sum of all the values if they are not columns in a table?

Thanks a lot