Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Make a groupby on distinct value

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


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



Super User
Super User

@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]))



Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

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 :

Irache_2-1683038885193.png    Irache_3-1683038934598.png



Resolver I
Resolver I

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.

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors