Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sum Column with two conditions

Hello all, I would like to calculate the sum of the respective plants via the customer in PowerBI. (Plant A1 => Customer 2 = 250) Unfortunately, I am still quite new to PowerBI and need help, as I ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Well, you could create a calculated table like:

    Table = SUMMARIZE('Table',[Plant],[Customer],"Sales",SUM('Table'[Sales]))

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Try:

Column = 
  VAR __Plant = [Plant]
  VAR __Customer = [Customer]
RETURN
  SUMX(FILTER('Table', [Plant] = __Plant && [Customer] = __Customer),[Sales])


Measure =
  VAR __Plant = MAX([Plant])
  VAR __Customer = MAX([Customer])
RETURN
  SUMX(FILTER('Table', [Plant] = __Plant && [Customer] = __Customer),[Sales])