cancel
Showing results for
Did you mean:
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

## Re: Calculated table summarize or groupby

Thanks! Great!

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 201 members 2,136 guests
Recent signins: