topic dividir resultados de diferentes tablas y relacionar por columnas in DAX Commands and Tips

dividir resultados de diferentes tablas y relacionar por columnas

Edimar90 — Wed, 20 Mar 2024 16:23:37 GMT

Tengo dos tablas relacionadas por Fecha y quiero dividir de tabla1/tabla2 cuando tabla1.Planta = tabla2.Planta, pero no he encontrado la forma correcta lo que mas me hizo sentido fue:

CALCULATE(DIVIDE(SUM(VentasPPTOGeneral[Act$]),tb_Admon_Gastos[GastoReal]),FILTER(VentasPPTOGeneral,DISTINCT(tb_Admon_Gastos[PlantaConbinada]) = distinct(VentasPPTOGeneralTotis[PlantaVts])))

Gracias.

Re: dividir resultados de diferentes tablas y relacionar por columnas

Anonymous — Wed, 20 Mar 2024 08:23:02 GMT

Hi Edimar90 ,

Would you be able to provide more information, such as some sample data (without privacy information) or pbix files. So that we can better understand and solve the problem you are experiencing.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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

Re: dividir resultados de diferentes tablas y relacionar por columnas

Edimar90 — Wed, 20 Mar 2024 15:41:23 GMT

Muchas gracias Anonymous

La idea es de las siguientes tablas independientes:

Dividir como ejemplo:

(Planta Kilos Planta 1 (VentasPPTOGeneral.[KG Ant])) / (PlantaCombinada Planta 1 (tb_Admon_Gastos.Anterior) )

en valores quedaria: (2,481,400)/(21,682,122) = 0.1144

Estas son tablas diferentes y estan relacionadas solo con fecha.

Gracias.

Re: dividir resultados de diferentes tablas y relacionar por columnas

Anonymous — Thu, 21 Mar 2024 06:09:54 GMT

Hi Edimar90 ,

Depending on the information you provided, you can follow these steps below:

1. Add a new table and create a relationship with your two tables.

Planta = DISTINCT('tb_Admon_Gastos'[PlantaCombinada])

2. Add a new measure.

Divide = DIVIDE ( SELECTEDVALUE ( VentasPPTOGeneral[KG Ant] ), SELECTEDVALUE ( 'tb_Admon_Gastos'[Anterior] ) )

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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