Calculated table summarize or groupby

[giorgiokatr]

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?

[v-qiuyu-msft · Accepted solution]

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

[giorgiokatr]

Thanks! Great!