DAX

[Anonymous]

hello all, 

Im pretty new to writing DAX, and am trying to do something that i would appreciate if someone can help me.

the all idea is to create a some kind of a translating visual.

here is what i'm doing:

i have 4 tables 
- Custumer(idcustomer,custumerNAme,)
-Account(idAccount,Accountname)
-CustumerAccount(idcustomer,idccount,idcountry) ---> with idcountry 1= french and 2= english

-dimtranslat(iddimtrans,LIB_French,LIB_English)----> 

what i want to do is when the AccountName = idcountry 1 then LIB_French should be displayed and when the idcountry = 2 then LIB_English should be display

this is how the dimtranslat look like

any idea of how can i implement the code ?

[kentyler · Accepted solution]

The first thing to do is change dimTranslate to have these columns.

Term_id, Language_id, Phrase

Then you can filter it in a CALCULATE statement by the term_id and the language_id and have it return the phrase in the desired language

trying to make DAX read across columns dynamically is just creating a lot of headaches you don't need.