Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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,
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.
Proud to be a Super User!
Hi kcantor,
Was hoping the total of GP, €3157.81 would be -€16642.2 (Ths sum of the GP totals)
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,
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
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |