cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
giorgiokatr Member
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 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])

 

q3.PNG

 

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

 

q4.PNG

 

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 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])

 

q3.PNG

 

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

 

q4.PNG

 

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
Member

Re: Calculated table summarize or groupby

Thanks! Great!