Error in the value retrieved from a dimension

[Syndicate_Admin]

Good afternoon

I'm building an array in Power BI by adding three-dimensional fields as rows, but retrieving data from the third dimension is transforming a value to uppercase.

Below I show the model and specify the fault:

The constructed matrix is as follows:

This problem only happens with a GALICIA, I have checked the dimension and it contains both the name in maysucula and in minuscula, but the relationship is by ID and the ID that is being used is that of the name in minusculas "Galicia". In fact, if we make a related to the FT and use this field it is shown correctly:

Although I have left the related column I would like to be able to understand what is happening and if I am lying any errors in the model.

Thanks a lot.

Greetings,

Daniel Neira

[amitchandak]

@Syndicate_Admin ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.