Forum Discussion

atin's avatar
atin
Icon for Advocate III rankAdvocate III
5 years ago
Solved

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 
 
 
DAX
Get Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    atin 

     

    Sorry for my mistake, I should enter, not /

     

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

4 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    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

    • atin's avatar
      atin
      Icon for Advocate III rankAdvocate III
      5 years ago

      Hi 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"

       

       

       

      • Fowmy's avatar
        Fowmy
        Icon for Super User rankSuper User
        5 years ago

        atin 

         

        Sorry for my mistake, I should enter, not /

         

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