Creating a new group with DAX

[AlessandroBet]

Hi,

i'm getting data from dataset so i can create new new group field. Can i do it working with DAX?

thanks

[tex628]

Can you provide an example of the desired outcome? 

[AlessandroBet]

I have a list of strings inside a field:

DN_AD

DS_AD

DW_AD

DN_AA

DS_AA

DW_AA

...etc

As you can see the first 3 end with AD and the last 3 with AA

I would like group named "AD" with the following string

- DN_AD

- DS_AD

- DW_AD

and a group named "AA" with the following string

- DN_AA

- DS_AA

- DW_AA

I hope this can help you understand what i need

[tex628]

Like this?

[AlessandroBet]

you have created a table.

I need to use this new goup to filter others things

[tex628]

Take a picture of the dataset please, im not quite sure what exactly it is you're looking for.

[AlessandroBet]

I need to create new measure with this new group "AD" AA"..etc

As you can see pressing rigth mouse botton i can't creata the new group

[tex628]

A group cannot be created on the table. Right now you are right clicking the Account table. You need to create the group on the column that you are using to define the different groups. 

[AlessandroBet]

with this dataset i can't create columns that why the reason i'm asking help to create these measure with DAX

[tex628]

Oh okay. Measures only hold scalar values so you will not be able to create a category using a measure. 

What kind of a query is it if you cant create calculated column? 

[AlessandroBet]

i dont need to create a query. I want only to create a new group with DAX that includes some strings

[tex628 · Accepted solution]

It's not possible to do with a measure.