Forum Discussion
Solved
Divide column not totalling
Hiya As you can see below, my PO Spend column is not totalling - it is doing the divide calculation along the totals. This is the calculation that PO Spend is doing - PO Spend = [PO unit *...
- Hi there
Please refer to this blog post below.
What essentially is happening is that your measure is working on the rows, but when it gets to the Total Column there is nothing for the column to filter by. So when that happens it displays the incorrect result for your column. This only happens when you use a table or matrix.
In order to resolve this, you need to identify the total row and when you do apply a slightly different measure.
This blog post does a great job explaining that.
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
Hi katrina890,
Based on my test, you could modify your measure of [PO Spend] = [PO unit * QTY]/[Part Conv Total] to [PO Spend] =SUMX(VALUES('Purchase Order Receipts'[BUY_UNIT_PRICE]), [PO unit * QTY]/[Part Conv Total]). It could work.
Also you can test with our sample report on your side to see if the same issue occurs.
https://www.dropbox.com/s/llu28zzeg7e89ef/Divide%20column%20not%20totalling2.pbix?dl=0
Regards,
Daniel He
Hi there
Please refer to this blog post below.
What essentially is happening is that your measure is working on the rows, but when it gets to the Total Column there is nothing for the column to filter by. So when that happens it displays the incorrect result for your column. This only happens when you use a table or matrix.
In order to resolve this, you need to identify the total row and when you do apply a slightly different measure.
This blog post does a great job explaining that.
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
Please refer to this blog post below.
What essentially is happening is that your measure is working on the rows, but when it gets to the Total Column there is nothing for the column to filter by. So when that happens it displays the incorrect result for your column. This only happens when you use a table or matrix.
In order to resolve this, you need to identify the total row and when you do apply a slightly different measure.
This blog post does a great job explaining that.
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/