What is the difference Between SUM() and SUMX()

0 votes

 What is the difference Between SUM() and SUMX()

Oct 20 in Power BI by Rajiv
• 4,560 points
48 views

1 answer to this question.

0 votes

Sum function (Sum()) takes the data columns and aggregates it totally but SumX function (SumX()) lets you filter the data which you are adding.

answered Oct 20 by anonymous
• 48,320 points

Related Questions In Power BI

0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

answered Oct 8 in Power BI by Gitika
• 48,320 points
24 views
+1 vote
3 answers

Difference between Power BI pro and Power BI Premium

My answer is applicable for a company ...READ MORE

answered Oct 30, 2018 in Power BI by chiranjeevi
• 160 points
731 views
0 votes
1 answer
+1 vote
1 answer
0 votes
1 answer

How do I label bar graph with different colors based on values from different slicers?

If the user selects only one value ...READ MORE

answered May 20, 2019 in Power BI by avantika
• 1,500 points
221 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What is the difference between PowerPivot, Power Query and Power BI?

Power Query Power Query is a self-service ETL ...READ MORE

answered Sep 24 in Power BI by Gitika
• 48,320 points
36 views
0 votes
1 answer

What is the difference between DAX and Power Query?

DAX stands for Data Analysis Expressions. DAX ...READ MORE

answered Sep 24 in Power BI by Gitika
• 48,320 points
29 views