SUMX and SUMMARIZE DISTINCT VALUES

[Anonymous]

Hi,

I need SUMX distinct values of the column 'Fact_Planned Orders'[Material/Plant (MP) Proportion * MaxDateMP], grouped by 'Fact_Planned Orders'[Planning Plant]. The formula that I´m using is the following:

Volume weighted avg PH per plant =

VAR PlantID = 'Fact_Planned Orders'[Planning Plant]

RETURN

CALCULATE(SUMX (DISTINCT(

    SUMMARIZE ( 'Fact_Planned Orders', 'Fact_Planned Orders'[Planning Plant], 'Fact_Planned Orders'[Material/Plant (MP) Proportion * MaxDateMP] )), [Material/Plant (MP) Proportion * MaxDateMP]

), FILTER('Fact_Planned Orders','Fact_Planned Orders'[Planning Plant] = PlantID))

The results are: 

However I think that the formula is summing some duplicate values because when I perform validations on excel removing the duplicate rows and summing the distinct values of [Material/Plant (MP) Proportion * MaxDateMP] column, the result is the following:

This result is more close of the result that I expect for the formula mencioned above. However I don´t know where is the mistake in my measure formula, because the Power BI result shown seems do be summing not the distinct values.

Anyone can help me with this situation?

Thank you

[lbendlin]

SUMMARIZE already does the grouping for you, no need for DISTINCT.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523