Forum Discussion
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...
Hi,
Write this measure
=Measure = SUMX(VALUES(Bonus[Seller]),[Commission Payable])
Hope this helps.
Hi AFRATH34
There is concept of row context and filter context. you can check the below link for better understanding this concept.
https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
You table is doing row wise calculation even your total value is calculated by row. To change the total value you have to use SUMX function which is filter context.
so instead of row wise calculation you total sum will be based on total of column value.
use below formula:
MAX Comms Pmt =
SUMX('Commission','Commission'[Eligible commission]) * [Achieved %])
I Hope I answered your question!