Forum Discussion

ofeliajesus's avatar
ofeliajesus
Helper I
4 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 think you can try to create a calculated table to achieve your goal.

Table 2 =
VAR _Non_California =
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Region ] <> "California" ),
        'Table'[Date_ID],
        "Region", "Non-California",
        "Amount", CALCULATE ( SUM ( 'Table'[Amount] ) )
    )
RETURN
    UNION ( 'Table', _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.

ofeliajesus's avatar
ofeliajesus
Helper I
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())