cancel
Showing results for
Did you mean:
Highlighted
giorgiokatr 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 v-qiuyu-msft
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 v-qiuyu-msft
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.
giorgiokatr Member

Thanks! Great!