What is the difference Between SUM and SUMX

0 votes

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

Oct 20, 2020 in Power BI by Rajiv
 • 8,870 points • 3,291 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, 2020 by anonymous
 • 65,770 points

Related Questions In Power BI

0 votes
1 answer

How to share Power BI reports to clients via app.powerbi? Also what is the difference between report and dashboard in power bi app?

There are 3 forms of Power BI- Power ...READ MORE

answered Feb 8, 2022 in Power BI by CoolCoder
 • 4,420 points • 2,769 views
+1 vote
1 answer

What is the difference between Power Pivot's Data Model and Power BI’s data model, and how can they be integrated effectively?

Power Pivot Data Model compared with Power ...READ MORE

answered Dec 2, 2024 in Power BI by pooja
 • 16,840 points • 112 views
0 votes
1 answer

What is the correct method to switch datasets between Power BI Desktop and Power BI Service?

Switching datasets on Power BI Desktop and ...READ MORE

answered Feb 28 in Power BI by anonymous
 • 19,330 points • 33 views
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, 2020 in Power BI by Gitika
 • 65,770 points • 1,853 views
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 21, 2019 in Power BI by Avantika
 • 1,520 points • 1,580 views
0 votes
1 answer

How can I make my visual distinct count total match the row by row sum when applying filters in PowerBI?

The COUNTROWS function can be used to ...READ MORE

answered Jul 28, 2020 in Power BI by Gitika
 • 65,770 points • 7,649 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 1,983 views
0 votes
1 answer

Error : Function 'GROUPBY' scalar expressions have to be Aggregation functions over CurrentGroup().

The error says you need to use ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 4,458 views
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, 2020 in Power BI by Gitika
 • 65,770 points • 2,119 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, 2020 in Power BI by Gitika
 • 65,770 points • 13,655 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.