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

1 Reply

  • 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