Total of Measure not as expected

[dkc]

Hi, I am already aware that my problem refers to how I built the measure, but although I was studying the other threats I was not able to get the correct measure. 

Measure for Conversion to cases: 

Conversion to cases = DIVIDE(SUMX(Sales,Sales[Bottles]), AVERAGEX('Bottles per case','Bottles per case'[Bottles per case]))

Problem: In the table the total shows in the column "conversion to cases" not the expected 28 cases but another value. I do understand what Power BI is calculating here, but I dont know how to change it to see my expected result.

Can you pls help me to create the right measure? 

Thank you very much for your support 

Daniela

[AlexisOlson · Accepted solution]

Get the total bottles for each separate value of bottles per case and then do the division.

Try something like this:

SUMX (
    SUMMARIZE (
        Sales,
        'Bottles per case'[Bottles per case],
        "@Bottles", SUM ( Sales[Bottles] )
    ),
    DIVIDE ( [@Bottles], 'Bottles per case'[Bottles per case] )
)

[AlexisOlson · Accepted solution]

Get the total bottles for each separate value of bottles per case and then do the division.

Try something like this:

SUMX (
    SUMMARIZE (
        Sales,
        'Bottles per case'[Bottles per case],
        "@Bottles", SUM ( Sales[Bottles] )
    ),
    DIVIDE ( [@Bottles], 'Bottles per case'[Bottles per case] )
)

[dkc · Accepted solution]

Thank you, it is working!

[Greg_Deckler]

@dkc 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

[dkc]

Thank you, I will check those sources!