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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      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 Ashish_Mathur ,

        It’s working perfectly! Thank you very much!