cancel
Showing results for
Did you mean:
Highlighted
Member

## Calculated table summarize or groupby

I have a table with a column areas and a column store code etc
Example
Area Store Code
a. 2
a. 2
a. 3
a. 3
a. 4
b. 5

How can i create a calculated table to have the unique values
Eg
a. 3
a. 4.
And so on
Should i use summarize or group by?
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Calculated table summarize or groupby

Hi @giorgiokatr,

It seems that you want to return unique pair of Area and Store Code, right?

You can create a table with DAX below:

Table = GROUPBY('Table1',Table1[Area],'Table1'[Store Code])

Table 2 = SUMMARIZE('Table1',Table1[Area],'Table1'[Store Code])

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator

## Re: Calculated table summarize or groupby

Hi @giorgiokatr,

It seems that you want to return unique pair of Area and Store Code, right?

You can create a table with DAX below:

Table = GROUPBY('Table1',Table1[Area],'Table1'[Store Code])

Table 2 = SUMMARIZE('Table1',Table1[Area],'Table1'[Store Code])

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

Thanks! Great!