Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to add two rows by a First name

I want to add up rows by First Name. So wherever there is a first name repeated I want to add them up so that the calculation of the rows give me an effort value of 1. For example I want to add the e...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I just used pivoting and it is working now

Anonymous's avatar
Anonymous
Not applicable
6 years ago

What formula should i use to write the same for a column. I will be using that for my traffic light system then

danextian's avatar
danextian
Super User
6 years ago

Try this as a measure

CALCULATE (
    SUM ( 'Table'[Effort Allocated] ),
    ALLEXCEPT ( 'Table', 'Table'[First Name] )
)

Replace Table with the actual table name. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    ITS GIVING ME WRONG RESULTS:

     

    • danextian's avatar
      danextian
      Super User
      6 years ago

      Hi Anonymous ,

       

      Please elaborate.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        So it should 1 but its showing different sum