Forum Discussion

CK1992's avatar
CK1992
Icon for Helper II rankHelper II
3 years ago

Total value is right but row values are wrong

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
Need Help