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.

MMPagola_1-1628821575775.png

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

3 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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