Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
zahids
Regular Visitor

SUMX CALCULATION TOTAL

Hi All

 

I am new to DAX, I am using SUMX in Power Bi Desktop and created a measure named MTD Var % Sumx and the the calculation is shown below 

 

                                    SUMX(

                                                  vw_DSF_Final,

                                                   vw_DSF_Final[CY MTD]/vw_DSF_Final[PY MTD]-1)*100 

 

 

 

 

Excel Total.jpg

 

 

 

 

 

I want the grand total to appear as -16.88 (as per above image) and this comes from the calculation as

 

 =((6065/7293)-1)*100

 

But the Grand Total I am getting in Power BI is different from Excel -- see below. How do I correct the DAX calculation above to get -16.84 as the grand total for the column MTD Var % SumX

PBI.JPG

 

 

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

The SUMX function should not be required.  Try this measure

 

=vw_DSF_Final[CY MTD]/vw_DSF_Final[PY MTD]-1

 

Format this measure as a %

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
v-jiascu-msft
Employee
Employee

Hi @zahids,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashish_Mathur
Super User
Super User

Hi,

 

The SUMX function should not be required.  Try this measure

 

=vw_DSF_Final[CY MTD]/vw_DSF_Final[PY MTD]-1

 

Format this measure as a %

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.