Forum Discussion
Incorrect total
Hello - The measure below is returning the correct amounts at the row level, but not at the total value level. Any advice on how to correct? Internal Use scale accrual % = SUM( Sh...
PaulDBrown I tried this approach, and it works perfectly. I referenced my original measure, in this measure:
SUMX( VALUES( 'Date Table'[MonthnYear]), [Internal Use scale accrual] )
Thanks for the help!
Hi Johanno I know what the issue is, just not sure how to fix it. The issue is that the total is being summed up incorrectly. I have tried using Sumx in replace of Sum. If you look at my first post, what I am trying to acheive is the correct total of the values in the Internal Use column. The reason why it is giving the current sum is because it is taking the sum of shipped price by the max % used in another column. So, it is doing what the formula is telling it to do, I just don't know how to change it to something else...which would be to sum up the values in the Internal use column.
Internal Use scale accrual =
SUM(Shipments[ShippedPrice])
* MAXX (
FILTER (
VIR_Table,
VIR_Table[Customer] = MAX ( Shipments[Primary Customer2] )
&& SUM( Shipments[ShippedPrice] ) > VIR_Table[Minimum Revenue]
),
.005 + VIR_Table[Incentive %]
)