Simple DAX question - using the SUM & DIVIDE Function

[atin]

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 

[Fowmy · Accepted solution]

@atin 

Sorry for my mistake, I should enter, not /

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

[Fowmy]

@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]

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 · Accepted solution]

@atin 

Sorry for my mistake, I should enter, not /

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

[atin · Accepted solution]

many thanks @Fowmy . It works now