Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Solved! Go to Solution.
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!