Forum Discussion

AFRATH34's avatar
AFRATH34
Helper I
1 year ago
Solved

Measure Help Needed - Totals Sum calculation

Hi All, I have a question about a measure I'm using to display the total Comms Payment.   The measure works correctly for each individual line item, but for the total, it calculates by multiplying...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Write this measure

    =Measure = SUMX(VALUES(Bonus[Seller]),[Commission Payable])

    Hope this helps.

     

anmolmalviya05's avatar
anmolmalviya05
Super User
1 year ago

Hi AFRATH34, I hope you are doing well,

To fix the issue where the total for Comms Pmt is not summing individual line items but instead recalculating based on totals, you can modify your measure to calculate the Comms Pmt per row and then sum the result.

 

Here's an adjusted DAX formula for Comms Pmt that should sum each row's individual value instead of recalculating based on totals:

Comms Pmt =

SUMX(

'Commission',

'Commission'[Eligible Commission] * [Achieved %]

)

Using SUMX ensures that the calculation is done row by row rather than recalculating based on total values, which is why your original measure was resulting in the total Comms Pmt as 268,955 * 30% = 80,686 instead of the sum of individual line items.

This adjusted measure should now provide the expected total for Comms Pmt. Let me know if this works for you!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

 

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in