Translate to arabic by calculated column based on another table

Anonymous — Wed, 14 Dec 2022 16:18:54 GMT

Hi,

I have table dim_language contain two rows:

Lang_Key Lang_Name

1 English

2 Arabic

In another table dim_field (without relationship with the first dim_language) i have the next columns:

Field_Name_key Field_name_English Field_Name_arabic

1 math ?????

2 english !!!!

3 history ######

I created the next measure:

Lang_Flag = if(calculate (SELECTEDVALUE(Dim_Language[Lang_Key])) =1, 1, 2)

then I created the next calulated column in dim_Field:

Field_Name_Dynamic = if([Lang_Flag] ==1, dim_Field[Field_name_English] , dim_Field[Field_Name_arabic])

for the change the displayed contect in the report.

I want every the value of Lang_Flag is changed the contect in Field_Name_Dynamic as well.

The result show that the value of meature is changeed by the change slicer, but the contect from Field_Name_Dynamic is not.

Why?

How I fix the Problem ?

Thanks, Barak

Re: Translate to arabic by calculated column based on another table

tamerj1 — Wed, 14 Dec 2022 17:33:30 GMT

Hi Anonymous

calculated columns do not interact with the filter context. What exactly are you trying to accomplish?