Forum Discussion
Summarize in DAX, HELP :)
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
Community ChampionHi 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
No, unfortunately it doesn't work, it's not what I expect. Total is not a dimension, but the total line of Power BI, where the sum must be calculated correctly
- Nathaniel_C
Hi 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 ColumnIn 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.
NathanielDim1 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
