In some CRM-Systems (customer relationship management) they use seperate tables to store the key-value pairs for listboxes, radiobuttons and checkboxes.
The situation can be described as by: we have a customer table that contains a column named GENDER_UID -> this is resolved within a reference table calles UC_TEXT (unicode text). It is linked by the language code and the UC_UID. The link between the two tables is made via the LOOKUPVALUE function as followed:
Gender LV = LOOKUPVALUE(BSI_UC_TEXT[TEXT],BSI_UC_TEXT[UC_UID],MIN('BSI_CUSTOMER'[GENDER_UID]))Code-Sprache: JavaScript (javascript)A detailed description on how it works can be found here:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax