How to use text columns in Measure?

Question

Hello All,&nbsp;I have a small scenario, where I would like to group the nationality into below categories.If Nationality="Indian" then "A1"if Nationality = "Australian" then "A2"If Nationality = "American" then "A3"else "Other"How would acheive it by using DAX measure.&nbsp;Kindly note, this can be achieved by adding group to the table, but I want to achieve this by measure.&nbsp;&nbsp;&nbsp;Regards,Sonu&nbsp;

mfelix · Accepted Answer

Hi&nbsp;sonuojha1&nbsp;,
&nbsp;
You can add the following measure:
Nationality group =
SWITCH (
    SELECTEDVALUE ( Table[Nationality] ),
    "Indian", "A1",
    "Australian", "A2",
    "American", "A3",
    "Other"
)
&nbsp;
Be aware that being a measure you need to have the nationality on your visualization otherwise these will not work properly, further more since it's a measure you cannot use it has a axis on visualizations or columns in a matrix visualization.
&nbsp;

Forum Discussion

How to use text columns in Measure?

2 Replies

Related content

Creating a Measure: Filtering Text Column, with text from another column

Measure two columns

Extracting complicated text from a column

Measure to SUM if column contains specific text or another column contains specific text

Calculate new column based on another column's text