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
Kudy
Helper I
Helper I

How to Group By with several columns?

Hi,

 

I have a simple table with 3 columns as shown in the attached picture:

- I tried to use Group By (in Query Editor) and could get the results in the column F, but not G.

 

please help

image.png

1 ACCEPTED SOLUTION
Jos_Woolley
Solution Sage
Solution Sage

4 REPLIES 4
colacan
Resolver II
Resolver II

Probably.. Because DAX makes new table using other data table(s). (in this case, the first table)

However, if the first table is also made from some other raw data, you can skip the first table and make the 2nd table using the raw data. Of cuase, you need different DAX code for it.

Thanks

Jos_Woolley
Solution Sage
Solution Sage

Hi,

Jos_Woolley_0-1632569523182.png

Regards

colacan
Resolver II
Resolver II

For number of product, we should use COUNT function and for Number of Cancelled Product, you can use SUM function.

If expressed in DAX, the table can be made as below 

=========================
ADDCOLUMNS(
    SUMMARIZE( OrderTable, OrderTable[OrderNumber] ),
    "TotNumberOfProduct", CALCULATE( COUNT( OrderTable[OrderNumber] ) ),
    "NumberOfCancellation", CALCULATE( SUM( OrderTable[Cancel] ) )
)

Thank you for a fast answer!

 

I tried this solution and got a new table with the result i wanted - Awesome!

So, if i want to transform/make my existing table to look like the new table then i have to do it in the query editor (with M language), isnt it?

Creating an additional table is abit messy right now , since i have too many tables and I am starting to loose track of them :).

 

 

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.