Forum Discussion
Incorrect total
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%
Anonymous
Not sure why the SUMX(SUMMARIZE)) measure isn't working. The measure firstly creates a virtual table with the relevante columns by SUMMARIZE and computes the SUM (your measure for each row). Then SUMX kicks in to add the values computed by your measure to calculate the total.
might be worth trying to include your measure as a VAR (which will compute the row values in memory) and the use the SUMX(SUMMARIZE()) as the RETURN.
Or try calculating you measure as a seperate measure and use that measure in the SUMX(SUMMARIZE()) measure.
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!