Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I have the table below :
Name | Power | Group | Status |
Group A | 2500 | On | |
Group B | 400 | OFF | |
Group C | 1200 | Pending | |
Group D | 1200 | On | |
Group E | 600 | Pending | |
Group F | 3600 | On | |
Name 1 | 200 | Group A | On |
Name 10 | 600 | Group F | On |
Name 11 | 1000 | Group F | On |
Name 2 | 200 | Group A | On |
Name 3 | 300 | Group B | OFF |
Name 4 | 400 | Group C | Pending |
Name 5 | 600 | Group C | Pending |
Name 6 | 200 | Group F | On |
Name 7 | 100 | Group C | Pending |
Name 8 | 200 | Group D | On |
Name 9 | 200 | Group D | On |
I would like to create the following matrix , the row subtotals are the value of the column Power
Could you please help.
Many thanks in advance.
HI @vnqt,
According to your snapshot, It seems like you are working with parent child hierarchy structure. I'd like to suggest you take a look the following blog about parent child hierarchy structure and how to analyze them in power bi.
Parent-child hierarchies – DAX Patterns
Regards,
Xiaoxin Sheng
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
23 | |
12 | |
11 | |
10 |