Single result now showing, all other results correct

[Richard_Japin]

Hi, I have made a report that works fine except the last row. For some reason, the final row does not end up correctly in the formula in the final column. Remarkably, the number 40 is included in the total of the column so that shows me it is an actual number. The result in the final column should be 0,95 x 0,68 x 40 = 26, but instead it is blank. In all other rows i do get a proper result. The data looks normal, so what could cause this?

[Anonymous]

Hi @Richard_Japin ,
Based on your description and the dax expression provided, we ran some tests and the dax code you created works fine when AANTALBIJ is located in the erpARTIKEL table, or when there is a one-to-one relationship between the erpARTIKEL and erpVOORRAADMUTATIES tables.
However, we notice that your last code uses expressions across tables for calculations, so that we need to take into account the relationship between the two tables.
So, can you provide the complete example data including the relationship between the tables or the pbix file so that we can help you faster.

Best regards,
Albert He

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

[bhanu_gautam]

@Richard_Japin , Can you share your dax code

[Richard_Japin]

Of course, first i calculate: 

daxFgas_CO2 = IF(erpARTIKEL[VVKOUDEMIDDEL] = "R32", 0.675, IF(erpARTIKEL[VVKOUDEMIDDEL] = "R410a", 2.088, 0))

Next, this is used in calculating

daxCO2_amount = sum(erpARTIKEL[daxFgas_CO2]) * SUM(erpARTIKEL[VVVERACFGAS])

which in turn is used to calculate 

daxCO2 = SUMX(erpVOORRAADMUTATIES, erpVOORRAADMUTATIES[AANTALBIJ] * [daxCO2_amount])