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 

 

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