Loosing key (link) after groupby

[Anonymous]

Hi, I have a table that is linked to another table through a key, and now I need to do some grouping in the first table to do some later visualization. However, after I do the groupby, the key is no longer included in the table and it became disconnected from the rest of tables. What should I do to keep the key (link) while grouping without the key...? 

[Greg_Deckler]

You either need to include the Key column in the GROUPBY group area or include it in the columns area like:

GROUPBY(

  'Table',

  [Some column],

  [Key],

  "Some aggregation",SUMX(CURRENTGROUP(),[Column])

)

or

GROUPBY(

  'Table',

  [Some column],

  "Key",MAXX(CURRENTGROUP(),[Key])

)

[Anonymous]

Thank you. ... However, where is EARLIER in the codes? And what do you mean by som column and some aggregation?

[Greg_Deckler]

Oh, never mind about the EARLIER, that's just a joke, it is in my signature.

You didn't provide sample data so I wasn't sure what kinds of columns and such I was dealing with so I just used place holders.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Thanks. I found a way to circumvent the problem... but I dont have a solution to the problem yet. Let me prepare the dataset and edit the question later...