Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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... 🙂
Solved! Go to Solution.
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
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
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
That helped, thanks!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
22 | |
21 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |