Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Irache
Helper II
Helper II

Make a groupby on distinct value

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

WeekShopSalesBuy
2008-05Shop210€-5€
2008-05Shop415€-25€
2008-05Shop415€-25€
2008-05Shop310€-25€
2008-05Shop310€-25€


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

WeekShopSalesBuy
2008-05Shop210€-5€
2008-05Shop415€-25€
2008-05Shop310€-25€

 

4 REPLIES 4
Tahreem24
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]))
 

Tahreem24_0-1683012707599.png

 

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 , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

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

Irache_0-1683038389098.pngIrache_1-1683038446113.png

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 :

Irache_6-1683039666905.png

 

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

Irache_4-1683039103102.pngIrache_5-1683039169098.png

 

Ghhousuddin
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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.