topic Re: dividir fila 1 entre fila 2 in DAX Commands and Tips

dividir fila 1 entre fila 2

Edimar90 — Tue, 21 May 2024 17:49:23 GMT

Requiero obtener el % de venta el cual se calcula

Gastos / Ventas

Pero los datos los tengo en categoria Planta y subcategoria Rubro como en el ejemplo de la imagen:

Planta = PLANTA 1 Y PASTAS

Rubro = [Kilos Ventidos],Ventas,Gastos

Values = Columna Anterior

El problema:

Al momento de dividir gastos / venta = ERROR

Lo correcto seria lo siguiente:
13,204,780 / 74,215,884 = 0.177922936281403

Gracias por la ayuda.

Re: dividir fila 1 entre fila 2

AnalyticPulse — Tue, 21 May 2024 18:09:58 GMT

hola Edimar90
can you explain your issue in English?

Learn Power BI free:

https://analyticpulse.blogspot.com

Power BI : getting started

Dax functions

powerbi Visualisation

Re: dividir fila 1 entre fila 2

Edimar90 — Tue, 21 May 2024 18:27:20 GMT

I need to split the rows

Row Expenses / Row Sales

But I have the data in the Plant category and the Category subcategory, as in the example in the image:

Plant = PLANT 1 AND PASTA

Item = [Kilos Sold],Sales,Expenses

Values = Previous Column

The problem:

At the time of splitting expenses/sales = ERROR

My table:

act = Value
Rubro = subcategory
Planta = category

My operation is:

Gastos = CALCULATE( SUM(tb_Admon_Gastos_Planta[act]), FILTER(tb_Admon_Gastos_Planta,tb_Admon_Gastos_Planta[Rubro] = "Gastos"))

Ventas = CALCULATE( SUM(tb_Admon_Gastos_Planta[act]), FILTER(tb_Admon_Gastos_Planta,tb_Admon_Gastos_Planta[Rubro] = "Ventas"))

DIVIDE(SUMX(tb_Admon_Gastos_Planta,tb_Admon_Gastos_Planta[Gastos]),SUMX(tb_Admon_Gastos_Planta,[Ventas]),0)

The correct thing to do would be the following:
13,204,780 / 74,215,884 = 0.177922936281403

Thanks for the help

Re: dividir fila 1 entre fila 2

Anonymous — Wed, 22 May 2024 06:55:07 GMT

Hi Edimar90 ,

Add the ALL or ALLSELECETED function in front of the tb_Admon_Gastos_Planta table, I'm not sure if it meets your expected results, please show the sample data in a usable form as well as the expected results.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: dividir fila 1 entre fila 2

Edimar90 — Wed, 22 May 2024 15:28:22 GMT

ya tengo los dos valores separados pero sigue mandando error en la divicion:

GastosAntALL = CALCULATE([GastosAnterior],ALL(tb_Admon_Gastos_Planta[PLANTA]))

VentasAntALL = CALCULATE([VentasAnterior],ALLSELECTED(tb_Admon_Gastos_Planta[PLANTA]))

%/VNAntPlantas = CALCULATE(tb_Admon_Gastos_Planta[GastosAntALL]/[VentasAntALL],ALLSELECTED(tb_Admon_Gastos_Planta[PLANTA]))

Gracias!