dividir fila 1 entre fila 2

[Edimar90]

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.

[v-tianyich-msft · Accepted solution]

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.

[Edimar90]

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!

[AnalyticPulse]

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

[Edimar90]

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