topic sum divided by count in DAX Commands and Tips

sum divided by count

Arendp — Mon, 10 Feb 2020 14:53:33 GMT

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 52488 .That is the result of the total divided by total count. (264382263/5037)

But I need to have the sum of Metingtest3 (so all results of that column summed up)

How can I accomplish that?

So calculation of Metingtest3 = sum(budgetrow)/Count(budgetrow)

Hopefully I am explaning myself in a good way... 🙂

Re: sum divided by count

Anonymous — Mon, 10 Feb 2020 19:10:58 GMT

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

Re: sum divided by count

Arendp — Tue, 11 Feb 2020 10:06:29 GMT

That helped, thanks!!

Re: sum divided by count

Anonymous — Tue, 11 Feb 2020 10:09:38 GMT

Are they columns or measure?

For column you have hasonevalue function.

There are more threads for total is wrong on community you can check those.

Thanks,

Pravin