Forum Discussion
subtotal does not sum, but
HI simolahansen,
Nope, current power bi has different calculation logic than what you want, you had to write a formula to control the calculation on total level.
You goal: calculate formula on row contents first, summary above result on total level.
What Power bi do: summary each row first and use formula calculate on summarized result.Maybe you can try to use below measures if it works:
Total=
SUM ( Table[Profit] ) * SUM ( Table[Units Sold] )
Earned= IF ( COUNTROWS ( VALUES ( Table[RoomName] ) ) = 1, [Total], SUMX ( VALUES ( Table[RoomName] ), [Total] ) )Reference link:
Subtotals and Grand Totals That Add Up “Correctly”
Regards,
Xiaoxin Sheng
Hi
I have a problem
When using matrix and using subtotals I have a similiar matrix as this:
| Price pr. m2 | Buying price | Selling price | Profit | Units Sold | Earned |
Subtotal | 7 | 70$ | 100$ | 30$ | 15 | 450$ |
Room1 | 4 | 20$ | 30$ | 10$ | 5 | 50$ |
Room2 | 10 | 50$ | 70$ | 20$ | 10 | 200$ |
As you can see the earned field in subotatal gets wrong number.
Because the subtotal-function does not sum "Earned" but uses the same formula as on the Rooms (Profit * Units Sold).
So Room1 is correctl Profit*Units Sold, and Room2 but not earned.
It should just sum the Earned-field.
How can I do this?