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 ...
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
)
  • atin's avatar
    atin
    5 years ago

    many thanks Fowmy . It works now 

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
)
      • atin's avatar
        atin
        Icon for Advocate III rankAdvocate III
        5 years ago

        many thanks Fowmy . It works now