connecting answer codes to values

Hi,

vanessafvg ,Thanks for your concern about the problem, and i want to offer some more information for user to refer to.

hello ant_lah , based on your description, you can refer to the following solution.

Sample data is the same as you provided.

You can create three calculated columns in table(ODK_DB_Correted).

Gender =
CALCULATE (
    MAX ( Choices[label::English] ),
    Choices[list_name] = "gender",
    Choices[name]
        = EARLIER ( ODK_DB_Correted[entire_survey-general_information-group1-gender] )
)

Age =
CALCULATE (
    MAX ( Choices[label::English] ),
    Choices[list_name] = "age",
    Choices[name]
        = EARLIER ( ODK_DB_Correted[entire_survey-general_information-group1-age] )
)

Education =
CALCULATE (
    MAX ( Choices[label::English] ),
    Choices[list_name] = "education",
    Choices[name]
        = EARLIER ( ODK_DB_Correted[entire_survey-general_information-group1-education] )
)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.