I have table dim_language contain two rows:
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.
How I fix the Problem ?