Forum Discussion

kfitzek's avatar
kfitzek
Regular Visitor
1 year ago
Solved

Measure not summarizing total amount showing in table

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 u...
Need Help
  • SamsonTruong's avatar
    SamsonTruong
    1 year ago

    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

SamsonTruong's avatar
SamsonTruong
Icon for Super User rankSuper User
1 year ago

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