Forum Discussion

Arendp's avatar
Arendp
Icon for Helper III rankHelper III
6 years ago
Solved

sum divided by count

Hello I have a problem with a Dax calc. I need to divide the sum of Metingtest 2 by count Metingtest. That results in Metingtest3. And that result is correct. However in the bottom , you see ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Arendp ,

     

    I think it needs to be something like this: 

     

    AvgRowAndTotal = 
    // My Dummy MetingTest3Berekening = Divide(sumx ( sales, Sales[Quantity] * Sales[Net Price]),sum(Sales[Quantity]))
    Var RowOrTotal = 
    IF ( ISFILTERED('Product'[Category]),     -- replace Product[Category] with your own fields
    Divide(sumx ( sales, Sales[Quantity] * Sales[Net Price]),sum(Sales[Quantity])), 
    SUMX(
    Summarize (                 -- create temporary table with the same subtotals
     Sales,                     -- you can check them in DAX studio
    'Product'[Category], 
    "rowtotal", Divide(sumx ( sales, Sales[Quantity] * Sales[Net Price]),sum(Sales[Quantity]))
    )
    , [rowtotal])
    )
    return RowOrTotal

    Hope this helps, 

     

    Jan 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Arendp ,

 

I think it needs to be something like this: 

 

AvgRowAndTotal = 
// My Dummy MetingTest3Berekening = Divide(sumx ( sales, Sales[Quantity] * Sales[Net Price]),sum(Sales[Quantity]))
Var RowOrTotal = 
IF ( ISFILTERED('Product'[Category]),     -- replace Product[Category] with your own fields
Divide(sumx ( sales, Sales[Quantity] * Sales[Net Price]),sum(Sales[Quantity])), 
SUMX(
Summarize (                 -- create temporary table with the same subtotals
 Sales,                     -- you can check them in DAX studio
'Product'[Category], 
"rowtotal", Divide(sumx ( sales, Sales[Quantity] * Sales[Net Price]),sum(Sales[Quantity]))
)
, [rowtotal])
)
return RowOrTotal

Hope this helps, 

 

Jan 

  • Arendp's avatar
    Arendp
    Icon for Helper III rankHelper III
    6 years ago

    That helped, thanks!!