Forum Discussion
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 ...
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
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
Thanks! Great!