Example 1: Reporting month = February. Everything works fine
Example 2: Reporting month = March.
Because there are no sales data in March from India in INR, the AdjustedRate is also filtered out, though the INR Exchange rate exists for March in Exchnage Rate table. As a result, the EUR Amount is not calculated, although the SalesYTD value is > 0.
I need to find a way to apply the INR rate from March, and thus calculate the EUR Amount for India.
I was trying differnet combinations of FILTER on AdjustedRate measure, but none seem to work, or maybe I am doing something wrong.