topic Re: Single result now showing, all other results correct in DAX Commands and Tips

Single result now showing, all other results correct

Anonymous — Wed, 12 Feb 2025 08:38:10 GMT

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?

Re: Single result now showing, all other results correct

bhanu_gautam — Wed, 12 Feb 2025 08:43:54 GMT

Anonymous , Can you share your dax code

Re: Single result now showing, all other results correct

Anonymous — Wed, 12 Feb 2025 08:50:43 GMT

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])

Re: Single result now showing, all other results correct

Anonymous — Thu, 13 Feb 2025 01:46:05 GMT

Hi Anonymous ,
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