Forum Discussion

giorgiokatr's avatar
giorgiokatr
Helper V
9 years ago
Solved

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?
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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