Forum Discussion

Regular Visitor

1 year ago

Solved

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 ...

1 year ago

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
)

Community Champion

1 year ago

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/n4TYhF2ARe8

You need to SUMMARIZE your table by all the columns in your visual, include the measure as a column and SUMX your Amount column.

Regular Visitor

1 year ago

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?