Properly split values in Power BI

[Scarthart]

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?

[bolfri]

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

[Scarthart]

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

[Scarthart]

@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 

[bolfri]

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.

[bolfri]

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/ 

[Scarthart]

@bolfri If you look here, he sent the data

https://wetransfer.com/downloads/054eab14acf0af548a576b42c9272d9f20221223155524/ea3cb238d9bcc03363fd...

[themistoklis]

@Scarthart 

Try the following formula on a measure:

% Share =
VAR numerator =
SUM(INVENTARIO.....[Disponibilitad]])
VAR denominator =
[Rotacion Promedio Mensual]

RETURN
DIVIDE ( numerator, denominator )

[Scarthart]

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

[Scarthart]

@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

[1Daniel993]

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

[Scarthart]

@1Daniel993 hello how can i do that