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,