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
atin
Resolver I
Resolver I

Simple DAX question - using the SUM & DIVIDE Function

Hi all 

 
My question is how do I apply the DIVIDE FUNCTION to the calculation below as I want to divide Total Sales by 10,000
 
At the moment, it shows like this in my reports and I am getting the correct numbers -however I also want to apply the DIVIDE function to the calculation.
 
Total Sales =
(SUMX(Sales,
Sales[Order Quantity] * Sales[Unit Price] ) / 10000) 
 
Many thanks 
 
 
2 ACCEPTED SOLUTIONS

@atin 

 

Sorry for my mistake, I should enter, not /

 

Total Sales =
DIVIDE(
    SUMX(
        Sales,
        Sales[Order Quantity] * Sales[Unit Price] 
    ) 
    , 
    10000
) 
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

many thanks @Fowmy . It works now 

View solution in original post

4 REPLIES 4
Fowmy
Super User
Super User

@atin 


Modify and try like this: 

Total Sales =
DIVIDE(
    SUMX(
        Sales,
        Sales[Order Quantity] * Sales[Unit Price] 
    ) 
    / 
    10000
) 

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

IMG_9042.jpgHi @Fowmy 
Many thanks for your solution. 

I seem to be getting an error with the updated formulae. I have included a photo. "Too few arguments were passed to the DIVIDE function. The minimum argument count for the function is 2"

 

 

 

@atin 

 

Sorry for my mistake, I should enter, not /

 

Total Sales =
DIVIDE(
    SUMX(
        Sales,
        Sales[Order Quantity] * Sales[Unit Price] 
    ) 
    , 
    10000
) 
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

many thanks @Fowmy . It works now 

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.

Top Solution Authors