Unusual Data Mismatch

Hi GanesaMoorthyGM,

Is you issue resolved? If not please follow the below approach.

Here the mismatch happens because your current measure calculates the last sales date in a cluster filtered context. So in the cluster dim visual this cuts off early, so you only see 0.25.
To fix it, please use the below measure:

Oman YTD Target =
VAR LastSalesDate = CALCULATE(
MAX('Fact_Sales_Master'[DateOnly]),
ALL('Fact_Sales_Master'),
'Fact_Sales_Master'[Country] = "Oman"
)

This way both visuals will consistently return 0.39 for Gold_Coins, matching your excel result.

Thanks and regards,

Anjan Kumar Chippa