Make a groupby on distinct value

[Irache]

Hello,
Is it possible to make a summarize table I want just to make a distinct select on my fact table for example:

Week	Shop	Sales	Buy
2008-05	Shop2	10€	-5€
2008-05	Shop4	15€	-25€
2008-05	Shop4	15€	-25€
2008-05	Shop3	10€	-25€
2008-05	Shop3	10€	-25€

And it is possible to make a groupby like this ? :

Week	Shop	Sales	Buy
2008-05	Shop2	10€	-5€
2008-05	Shop4	15€	-25€
2008-05	Shop3	10€	-25€

[Tahreem24]

@Irache You can also utilize SUMMERIZE DAX to achieve the expected output. Create a new table using below DAX:

Table 2 = SUMMARIZE('Table','Table'[Week],'Table'[Shop],"Sales",MAX('Table'[Sales]),"Buy",MAX('Table'[Buy]))

[Irache]

The problem is my week column is from my date table so when I make the same formule it's done that :

The result is good for the IN but it is false for the OUT because we muste have minus 4 OUT in total in "OUT" column in the third line for the week five of 2008. 

Here is the table that summarizes the number of entries and exits per week :

For the futher information in my Fact Data table I have a two important Date the date for the IN and the date for the OUT, and my Date table are link on the two date :

    

[Ghhousuddin]

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.

[Irache]

Hello, I don't want to make a groupby on Sum I just wan't the unique value.