cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandro1995
Frequent Visitor

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 don't know how to do it. The SumX formula did not work for me, so I am quite confused how i can calculate a something like a sumif with two conditions in PowerBI.


Thank you very much for your help.

 

sandro1995_0-1666172723422.png

 

Best Regards
Sandro

 

1 ACCEPTED SOLUTION

@sandro1995 Well, you could create a calculated table like:

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
sandro1995
Frequent Visitor

@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

@sandro1995 Well, you could create a calculated table like:

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.