Make a groupby on distinct value

Yes, it is possible to create a summarized table in Power BI using the Group By feature. Here's how you can create the table you mentioned:

1. Select the "Transform Data" option in Power Query Editor.
2. Select the fact table that you want to summarize.
3. Go to the "Add Column" tab and click on "Group By".
4. In the Group By dialog box, select the following:
a. Week as the grouping column
b. Shop as the second grouping column
c. Sales as the aggregation column, and choose "Sum" as the operation
d. Buy as the aggregation column, and choose "Sum" as the operation
5. Click OK to create the summarized table.

This will create a new table that summarizes the data based on the Week and Shop columns, and displays the total Sales and Buy amounts for each group. You can then use this summarized table for further analysis or visualization in Power BI.