Forum Discussion

ofeliajesus's avatar
ofeliajesus
Helper I
3 years ago
Solved

Grouping using the same value twice

Hello,   I have the below regions  Basically, I want to have all the below plus Non-California (with all except California) in the same field is it possible with Groups  can I use the same field ...
Show and Tell
  • ofeliajesus's avatar
    ofeliajesus
    3 years ago

    Thank you Rico,

     

    Your solution works ... 

    In the Union, I needed to change it to have the same fields same order ...

    UNION(

    SELECTCOLUMNS(), 
    SELECTCOLUMNS())
     
     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ofeliajesus ,

 

I suggest you to create a calculated column by dax.

Group = 
IF('Table'[Region] = "California",'Table'[Region],"Non-California")

Result is as below.

 

Best Regards,
Rico Zhou

 

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