Measure not summarizing total amount showing in table

[kfitzek]

Hello all,

I have a measure that is doing some basic divison to calculate a conversion of weights. The amounts are coming out right in my table view, but the summary at the bottom is not adding up. I have a feeling the measure it's summing completely and its only counting certain line items. Any help would be great! Formual below and table showing the disconnect.

Converted KG (weight UoM only) =

DIVIDE(

    SUM('secure_prh_summary'[Qty]),

    SUM('Um conversion'[Conversion ])

)

[SamsonTruong · Accepted solution]

Hi @kfitzek ,

Please try the following DAX measure and let me know if this achieves your desired result:

Converted KG (weight UoM only) =
SUMX(
    'secure_prh_summary',
    'secure_prh_summary'[Qty] / RELATED('Um conversion'[Conversion])
)

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson