cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

dividir fila 1 entre fila 2

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.

1 ACCEPTED SOLUTION
Community Support

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.

4 REPLIES 4
Community Support

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.

Frequent Visitor

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

Gracias!

Impactful Individual
Frequent Visitor

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:

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

Thanks for the help

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.