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.

     

AFRATH34's avatar
AFRATH34
Helper I
1 year ago

Hi anmolmalviya05 and Uzi2019 
First, thank you very much for your suggestions. However, if I change the SUMX formula, both the individual values for each row and the total value also change. The output does not meet the expected result.

Uzi2019's avatar
Uzi2019
Community Champion
1 year ago

Hi AFRATH34 

can you share the result and expected output??

 

  • AFRATH34's avatar
    AFRATH34
    Helper I
    1 year ago

    Hi Uzi2019 ,

     

    Please find the attached PBIX file for your reference along with my expected output.

    Kindly review it and share your output based on the provided PBIX file.


    https://drive.google.com/drive/folders/1QhkcS8opYdvcyMbUPvrrbiOl-Qvu7vRU?usp=drive_link 

     

    my output shoud be commission payable total $216,152 (each individual line item Total)

     

    Please let me know if anyone can assist me with a specific measure to tweaking my existing methodology above to reach this expected total.
     
    I appreciate the assistance as always!

    Thanks,

    Afrath

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      Access Denied message.

      • AFRATH34's avatar
        AFRATH34
        Helper I
        1 year ago

        Hi Ashish_Mathur ,

        Access has been granted; please try again now

        Thanks,

        Afrath