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]))

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Greg_Deckler 

 

Thank you for your fast response/help. 

 

The suggestion worked. But Is there a possibility to get the resulting values in a seperate row? As I want to use the resulting values in a Slicer for numeric ranges?

 

For example I just want to see customers which sales are higher than 300 in the visualization.

 

Thank you!

 

Kind regards

Sandro

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Well, you could create a calculated table like:

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