Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |