Forum Discussion
Solved
Summarize in DAX, HELP :)
I have the following data: Dimension1, Dimension2, Value1, and Value2. Now, I want each row to be calculated first in Power BI (PBI), and then the sum of all individual positions from Dimension2 sho...
Hi PWRBI ,
If I understand your issue correctly, you might try this.Column = IF(Summary[Dim2]="Total",Sumx(Summary,Divide(Summary[Val1],Summary[Val2])),Divide(Summary[Val1],Summary[Val2]))
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Nathaniel_C
Community Champion
Community ChampionHi PWRBI ,
If I understand your issue correctly, you might try this - it was not clear in your picture.
Add a column to your table and add it to the visual.
If this is not what you wanted, please add some more explanation.
Column = Divide(Summary[Val1],Summary[Val2])Original table
With Calculated Column
In Visual
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
| Dim1 | Dim2 | VAL1 | VAL2 | VAL3 | VAL4 | Result | Measure |
| A | AA | 0 | 37183,52 | -49785,07 | -51570,17 | 38516,7772 | VAL1+(VAL2/VAL3*VAL4) |
| A | BB | 0 | 6234,33 | -65,73 | -59 | 5596,00593 | VAL1+(VAL2/VAL3*VAL4) |
| 0 | 43417,85 | -49850,8 | -51629,17 | 44966,7319 | this is the result that is displayed | ||
| 44112,7831 | this is the result I expect |