cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
PWRBI
Frequent Visitor

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

 

Here's how it should look:

Dimension 1Dimension 2Wert 1Wert 2Ergebnis
AAA15= 1/5 --> 0,2
ABB1010= 10/10 --> 1
ATotal  

= 1,2

 

But that's how it looks in PBI:

Dimension 1Dimension 2Wert 1Wert 2Ergebnis
AAA15= 0,2
ABB1010= 1
ATotal  

= 0,73

 

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

1 ACCEPTED SOLUTION
Nathaniel_C
Super User
Super User

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

Nathaniel_C_0-1688565596556.png


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









Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

6 REPLIES 6
Nathaniel_C
Super User
Super User

Hi @PWRBI ,

Nathaniel_C_0-1690573920339.png

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

Nathaniel_C
Super User
Super User

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

Nathaniel_C_0-1688565596556.png


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









Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

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

Nathaniel_C_0-1689277827657.png


With Calculated Column

Nathaniel_C_1-1689277886450.png

In Visual

Nathaniel_C_2-1689277944914.png


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







Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Dim1Dim2VAL1VAL2VAL3VAL4ResultMeasure
AAA037183,52-49785,07-51570,1738516,7772VAL1+(VAL2/VAL3*VAL4)
ABB06234,33-65,73-595596,00593VAL1+(VAL2/VAL3*VAL4)
  043417,85-49850,8-51629,1744966,7319this is the result that is displayed
      44112,7831this is the result I expect

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors