Forum Discussion
Measure Total Incorrect
I know there are a bunch of threads about this matter, but none of the solutions that I've found seem to work for my particular measure. Below is the data that I am working with:
Amount is the measure that I have created in my report. I am able to get the line level calculations correct, but my total is showing as $22.02, instead of the $18.53.
The measure that I am using for amount is as follows:
Amount =
((UnitCost*QtyPer)*.25)*ShippedQty
t_young
This should work for you:Amount = SUMX( SUMMARIZE( Table, Table[Parent Part] , Table[Sub Part] , Table[Order #] ), VAR ShippedQty = CALCULATE( AVERAGE(Table[Qty]) ) VAR UnitCost = CALCULATE( AVERAGE(Table[Unit Cost]) ) VAR QtyPer = CALCULATE( SUM(Table[QtyPer]) ) RETURN ( ( UnitCost * QtyPer ) * .25 ) * ShippedQty )
3 Replies
- Fowmy
Super User
t_young
This should work for you:Amount = SUMX( SUMMARIZE( Table, Table[Parent Part] , Table[Sub Part] , Table[Order #] ), VAR ShippedQty = CALCULATE( AVERAGE(Table[Qty]) ) VAR UnitCost = CALCULATE( AVERAGE(Table[Unit Cost]) ) VAR QtyPer = CALCULATE( SUM(Table[QtyPer]) ) RETURN ( ( UnitCost * QtyPer ) * .25 ) * ShippedQty ) - Greg_Deckler
Community Champion
t_young First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8You need to SUMMARIZE your table by all the columns in your visual, include the measure as a column and SUMX your Amount column.
Unless I am doing it wrong, I have tried that many times with no success.
Could you provide the DAX that i should be entering?
