Measure doesn't add up

[android1]

Hi,

I have this measure -> GP = - 1800 + SUM(vw_PivotVisitsInvoiced[Income Generated])

Calc Column -> Income Generated = vw_PivotVisitsInvoiced[Visits_NoHrs] * 6.25

Why is my total below not right?

Thanks,

Gerry

[dkay84_PowerBI]

https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/?nabm=0&utm_refer...

[kcantor]

what are you expecting the number to be and why is it wrong? Your snip has no context for us to determine the source of the error.

[android1]

Hi kcantor,

Was hoping the total of GP, €3157.81 would be -€16642.2 (Ths sum of the GP totals)

[v-sihou-msft · Accepted solution]

@android1

Your GP is a measure. At the grand total, it will just sum all data together first, then minus 1800. If you want your expression be evaluated on each row, you should use SUMX().

GP =SUMX(vw_PivotVisitsInvoiced,vw_PivotVisitsInvoiced[Income Generated]-1800)

See sample below:

Regards,

[android1]

Hi Simon,

Thanks very much.

See the GP column. 1800 is subtracted from Income Generated each week. (The total of -1000 is correct)

How would I show GP to start at -1800 & add Income Generated to it each week.

So in attched,

I would like to see:

Wk 10 GP = -1712.5

Wk 11 GP = - 1603.12 ( - 1712.5 +109.38)

Wk 12 GP = - 1499.99 ( - 1603.12 + 103.13)

Gerry