Forum Discussion

Meneghetti's avatar
Meneghetti
New Member
8 years ago
Solved

Help New Measure - SUMIF Equivalent

Hello Guys    First time here, first of all I'm sorry that English is not my native language. I am trying to make a sum of a column only when my product is a "lançamento" in the lançamento column. ...
  • parry2k's avatar
    parry2k
    8 years ago

    Add a measure  as below, change column name and table name as per your data table.

     

    Sum of Lancamento =

Calculate(
  Sum(Table[MAT Atual]), 
  Filter(
     AllSelected(Table), 
    Table[Lancamento] = "Lancamento"
  )
)
parry2k's avatar
parry2k
Super User
8 years ago

Add a measure  as below, change column name and table name as per your data table.

 

Sum of Lancamento =

Calculate(
  Sum(Table[MAT Atual]), 
  Filter(
     AllSelected(Table), 
    Table[Lancamento] = "Lancamento"
  )
)
Meneghetti's avatar
Meneghetti
New Member
8 years ago

Thanks! It worked!