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.

Helper I
Helper I

Properly split values in Power BI

Very good days, I want to divide two columns but when checking the division in excel, I identify that power bi did the division wrong


How can I divide these values correctly?

Captura de pantalla (165).pngCaptura de pantalla (168).pngCaptura de pantalla (169).png

Super User
Super User


data that you're comparing with are different.

Record ArticuloSourceDispon ValueRotationCalculator
BUJA UNIVERSAL CORTAExcel on your screen13425355= 13425 / 355 = 37,8169014084507
BUJA UNIVERSAL CORTAPower BI134250352= 134250 / 252 = 381,3920454545455


Different data = Different results 🙂

Both programs did thier job and gave correct results based on provided data.


Dispon = SUM(Hoja1[Disponibilidad])
Rotation = SUM(Hoja1[Rotación Promedio Mensual])
Share = DIVIDE([Dispon],[Rotation])


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

Proud to be a Super User!

@bolfri How could I split the non-summarized data as it is splitting me only the grouped correctly

@bolfri Hi, 
How strange since all I did was export the data.


Even so, I already discovered what is happening, is that when dividing the data accumulates and I do not want it to accumulate, I only take the value visible in the table


@bolfri Captura de pantalla (172).pngCaptura de pantalla (173).pngCaptura de pantalla (174).pngCaptura de pantalla (175).png

Is that solved your problem or do you need a SUMX calculation (measure that performes row by row and then agregate the result)? I am sorry, but I don't understand the meaning of this columns and their business meaning.

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

Proud to be a Super User!

Super User
Super User

Can you put in here like... I don't know 6-7 example rows from you data? You can share it via 

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

Proud to be a Super User!

Community Champion
Community Champion



Try the following formula on a measure:

% Share =
VAR numerator =
VAR denominator =
[Rotacion Promedio Mensual]

DIVIDE ( numerator, denominator )

@themistoklis Is there a way to do it without the need for SUM or SUMX , but to divide the values without grouping them

@themistoklis Hello, thank you very much, for answering it still does not give me what it should give me, that is, what is calculated for me in Excel, it should be the same calculation in Power BI

Captura de pantalla (170).png

Helper III
Helper III

Hola, podrias mejor generar una columna formulada con la misma expresion y evitarias errores en la medidas

@1Daniel993 hello how can i do that

Helpful resources

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