topic Re: Summarize in DAX, HELP :) in DAX Commands and Tips

Summarize in DAX, HELP :)

PWRBI — Wed, 05 Jul 2023 12:44:01 GMT

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 should be added for Dimension1.

Here's how it should look:

Dimension 1	Dimension 2	Wert 1	Wert 2	Ergebnis
A	AA	1	5	= 1/5 --> 0,2
A	BB	10	10	= 10/10 --> 1
A	Total			= 1,2

But that's how it looks in PBI:

Dimension 1	Dimension 2	Wert 1	Wert 2	Ergebnis
A	AA	1	5	= 0,2
A	BB	10	10	= 1
A	Total			= 0,73

I've already tried Summarize with no success. Can you help me please?

Re: Summarize in DAX, HELP :)

Nathaniel_C — Wed, 05 Jul 2023 14:00:15 GMT

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

Re: Summarize in DAX, HELP :)

PWRBI — Thu, 13 Jul 2023 07:58:27 GMT

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

Re: Summarize in DAX, HELP :)

Nathaniel_C — Thu, 13 Jul 2023 19:52:39 GMT

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 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

Re: Summarize in DAX, HELP :)

PWRBI — Wed, 26 Jul 2023 17:47:43 GMT

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

Re: Summarize in DAX, HELP :)

Nathaniel_C — Fri, 28 Jul 2023 19:56:06 GMT

Hi PWRBI ,

How do you get 38,516.78 on the first row based on this formula. If you wish me to look at this please include an explanation of what you are trying to do and make your example much clearer than what you did here. Otherwise you may want to re post this.

Thank you,

Nathaniel

Re: Summarize in DAX, HELP :)

PWRBI — Mon, 31 Jul 2023 05:59:24 GMT

Hi, how can I Upload a PBI File for you with an example?