Forum Discussion

aggarwal25's avatar
aggarwal25
Frequent Visitor
9 years ago
Solved

Sum column values based on another column

Hi All   I have some data and I want to sum 'Translated Ampount' based on 'revenue Category' column and then be able to map it with the customer. PLease let me know how can I do that. Apprecaite an...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    HI aggarwal25,

     

    You can take a look at below formulas if it suitable for your requirement:

     

    Calculate column:

     

    Sum Group = CALCULATE(SUM('Table'[Translated Ampount]),FILTER(ALL('Table'),[Revenue Catagory]=EARLIER('Table'[Revenue Catagory])) )

     

     

    Measure:

     

    Sum group 2 =
var catagory=LASTNONBLANK('Table'[Revenue Catagory],[Revenue Catagory])
return
CALCULATE(SUM('Table'[Translated Ampount]),FILTER(ALL('Table'),[Revenue Catagory]=catagory))

     

     

    Regards,

    Xiaoxin Sheng

Neftali's avatar
Neftali
New Member
4 years ago

Hi all

 

I have this data and I want to sum "Total Qty Per Request" based on the "Material Name." So I want the sum of the "Total Qty Per Request" for "Bot Bev G5," "Dexron LS Gear Oil 75W-90," etc. How would I be able to make a measure for this?

JanaLyn's avatar
JanaLyn
Regular Visitor
2 years ago

I have the same question about how to sum a column based on another column and cannot get a solution using the result provided. The "EARLIER" command isn't understood in my expression. Got any tips?