Forum Discussion

android1's avatar
android1
Post Patron
9 years ago
Solved

Measure doesn't add up

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 ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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's avatar
android1
Post Patron
9 years ago

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