Total value is right but row values are wrong

[CK1992]

Hi team,

I face the following issue.

The total value is right. However, if you summarize the row values, the result is completely different that is wrong.

I think that i miss something in my filters but i can not understand what. The issue is coming when i bring the Load Country in my table.

Could you please help with it?

The function is the following.

CurrentValue =

VAR DataMaxDate = calculate(MAX('C_Shipments_Iron_Ore_Iron_Ore_Report - Detailed'[Date]),ALL('C_Shipments_Iron_Ore_Iron_Ore_Report - Detailed'[Date]))

RETURN

CALCULATE(SUM('C_Shipments_Iron_Ore_Iron_Ore_Report - Detailed'[intake_mt]), FILTER('C_Shipments_Iron_Ore_Iron_Ore_Report - Detailed', 'C_Shipments_Iron_Ore_Iron_Ore_Report - Detailed'[Date] = DataMaxDate))

What i do is to take the latest date from a date column (MAX) and then I filter my calculation for this date. The goal is to show just the values of the last date.

Thanks,

Christos

[lbendlin]

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