#### John Jairo V

##### Well-Known Member

crossposted at : https://www.mrexcel.com/forum/power-bi/1101200-total-puestotrabajo-wrong-calculation.html#post5294912

The idea of the table that I present in the file is to distribute a quantity of KG of production in several Puestos de Trabajo, through participations. I calculate these participations satisfactorily, both in percentage (Measure

**% Participación KG Real Puesto Trabajo**) and in values (

**Measure KG Real Puesto Trabajo por Mat = [Total KG Produccion IDO] * [% Participación KG Real Puesto Trabajo]**).

At the time of adding these values disconnecting the material with ALL, the resulting value is wrong ... and I can not find the reason for this situation.

Wrong measure:

**KG Real Totalizado Puesto Trabajo = IF(ISNUMBER([Total KG Produccion IDO]) ; CALCULATE( [KG Real Puesto Trabajo por Mat] ; ALL(fIDO[Material])) ; BLANK() )**

Could you help me calculate the correct value?

Could you help me calculate the correct value?

To give examples of what you should give:

For PuestoTrabajo

**6702041**, it should give:

**27164.54 + 1601.96 = 28766.5**(it's giving 20266.77 <- Wrong. I do not even know where the value comes from)

For PuestoTrabajo

**6702043**, it should give:

**1609.11 + 10072.59 + 11160 + 764 + 3264 + 20807.55 + 4546.68 = 52223.93**(it is giving 48863.03 <- Wrong, nor do I know where the value comes from).

and so for all the PuestosTrabajo that appear, according to the Plant filter.

If you require more information, I will gladly supply it.

I greatly appreciate the help you can give me. Blessings!

**link of file: https://mega.nz/#!hgBCQKAL!6pDDp0mbN7NBaX878V1gobDflweNWzmQY-4v-yWa7OQ**

crossposted at : https://www.mrexcel.com/forum/power-bi/1101200-total-puestotrabajo-wrong-calculation.html#post5294912