Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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
Super 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
    Administrator
    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