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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
muggydaniel
New Member

Grouped Rows into Individual Rows

Hi team 

 

Unsure how to explain. Showcasing example: 

 

Customer IDCount of ApplicationsArea
12453Bendigo
12674Melbourne
12891Gippsland

 

 

Each application would have 1x "main" application and the rest would be "child" applications

 

I would need to convert the above table where for the customer ID, each row is representative of 1x main app and the rest count of applications is child applications 

 

Customer IDApplication TypeArea
1245MainBendigo
1245ChildBendigo
1245ChildBendigo
1267MainBendigo
1267ChildBendigo
1267ChildBendigo
1267ChildBendigo
1289Main

Gippsland

 

Does anyone know how this can be achieved? 

1 ACCEPTED SOLUTION

Hi @muggydaniel 

His this that you want? 

onurbmiguel__0-1681805349802.png

 

 

take a look at power query in this file: 

counts.pbix

 

onurbmiguel__1-1681805639262.png

 

 

Best regards

Bruno Costa | Power Participant

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


View solution in original post

3 REPLIES 3
muggydaniel
New Member

Is it possible to complete that within the query itself to create individual rows instead of a measure inside? 

 

I am also appending the changes into another table that requires them to be single/individual rows

Hi @muggydaniel 

His this that you want? 

onurbmiguel__0-1681805349802.png

 

 

take a look at power query in this file: 

counts.pbix

 

onurbmiguel__1-1681805639262.png

 

 

Best regards

Bruno Costa | Power Participant

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


onurbmiguel_
Power Participant
Power Participant

hello @muggydaniel 

Please try this mesure: 

Measure = 
COUNTX('Table','Table'[Customer ID])

 

Best regards

Bruno Costa | Power Participant

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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