Forum Discussion
Incorrect total
- Anonymous5 years ago
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!
PaulDBrown Thanks for staying with me on this! Your measure resulted in the same total value (note on my "Internal Use" measure I have hidden the total), but it comes out to the same $95,661 as yours). I literally had to show this to people today and did not want to confuse them by showing a total which is not correct.
The VIR table is populating my visual with just the Customer name (related to the shipments table).
All of the other columns below are measures. Month comes from the date table.
The guts of the measure works perfectly fine...it is getting the correct row totals. But what seems to be happening is that your measure, and mine, are grabbing the total value from the shipped revenue column and seeing if it is under/over the minimum revenue amount (VIR table), and then multiplying it times the Incentive %. I do not want anything to be multiplied by the sum total. Rather, I just want the column values to be added up. So, in the example below, I need the "with totals" column to add up to $50,775.
VIR Table
Customer Name Minimum Revenue Incentive %
Customer A 500,000 1.5%
Customer A 700,000 2.5%
Hi,
Share the link from where i can download your PBI file.