Forum Discussion

User5231's avatar
User5231
Helper II
6 years ago
Solved

How to Sum Distinct Based on another Column Value

So I am trying to make a measure that sums a column, but sums it distinctly based on criteria. Order Operation Yield Area ID1 1 1 area1 ID1 2 1 area2 ID1 3 1 area3 ID2 1 1 area1 ID2 2 1 area2 ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    User5231 try this measure:

     

    Yield Sum = 
CALCULATE ( 
    SUM ( TableTest[Yield] ),
    FILTER ( 
        ALLEXCEPT ( TableTest, TableTest[Area], TableTest[Order] ), 
        TableTest[Operation] = MAX ( TableTest[Operation]  )
    )
)

     

    I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

parry2k's avatar
parry2k
Super User
6 years ago

User5231 try this measure:

 

Yield Sum = 
CALCULATE ( 
    SUM ( TableTest[Yield] ),
    FILTER ( 
        ALLEXCEPT ( TableTest, TableTest[Area], TableTest[Order] ), 
        TableTest[Operation] = MAX ( TableTest[Operation]  )
    )
)

 

I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

  • User5231's avatar
    User5231
    Helper II
    6 years ago

    I will try this and let you know. Also, would it be possible to make a calculated column that did the same thing? Like gave you an indicator for the last operation for each order out of each area? That would be more ideal because I could turn on the Y or N indicator with a filter.

     

    • User5231's avatar
      User5231
      Helper II
      6 years ago

      Anyone know a way to do the column indicator request? Would really be helpful.

       

      Thanks again.