Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

Total for a calculated column

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...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

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