cancel
Showing results for
Did you mean:

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

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?

11 REPLIES 11
Super User

Hi,

data that you're comparing with are different.

 Record Articulo Source Dispon Value Rotation Calculator BUJA UNIVERSAL CORTA Excel on your screen 13425 355 = 13425 / 355 = 37,8169014084507 BUJA UNIVERSAL CORTA Power BI 134250 352 = 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])``````

Proud to be a Super User!

Helper I

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

Helper I

@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

Super User

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.

Proud to be a 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 https://wetransfer.com/

Proud to be a Super User!

Helper I
Community Champion

Try the following formula on a measure:

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

RETURN
DIVIDE ( numerator, denominator )

Helper I

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

Helper I

@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

Helper III

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

Helper I

@1Daniel993 hello how can i do that

Announcements

#### Power BI Monthly Update - November 2023

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

#### Fabric Community News unified experience

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

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