The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a table as follows:
Parent ID Child ID Child Status Child Points
1 1 Open 2
1 2 Open 1
1 5 Closed 5
2 8 Dev null
2 3 Review 1
I need this table in tact, but I need a new table as follows (I am eventually a group by):
Parent ID # of Children # of Child Points
1 3 8
2 2 1
Solved! Go to Solution.
I think I may have figured it out, I had to:
1) Duplicate the table (since I need to original details)
2) On the Duplicated table use the Group By with multiple conditions
Hi @EaglesTony ,
If you're using Power BI, then you may not need to physically create the second table (depending on your requirements).
The second table can be visualised based on the first table with the following measures:
// If [Child ID] is always unique per [Parent ID]
noofChildren = COUNTROWS(Table1)
// If [Child ID] is NOT always unique per [Parent ID]
noofUniqueChildren = DISTINCTCOUNT(Table1[Child ID])
noofChildPoints = SUM(Table1[Child Points])
Use these measures along with your [Parent ID] column in a table/matrix visual and it will output your second table.
Pete
Proud to be a Datanaut!
Yes, use the 'Group By'. What are you having difficulty with?
I think I may have figured it out, I had to:
1) Duplicate the table (since I need to original details)
2) On the Duplicated table use the Group By with multiple conditions
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
20 | |
19 | |
17 | |
13 |