Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I'm working on a matrix table and I need to calculate Total on multiple levels. Please find the Data below.
Master Data:
ID | Class | Code | Sub Class |
AC02 | Less than 1 year | XCB | Bills |
AC02 | Less than 1 year | MNB | Funds |
AC22 | Greater than 1 year | Deposits |
Source Data:
Code | Value | ID |
XCB | 8912168.726 | AC02 |
MNB | 2556852 | AC02 |
ABC | 9983215 | AC02 |
OAS | 18558732.49 | AC22 |
OAS | 1001377.5 | AC22 |
OAS | 8739399 | AC04 |
Expected Result:
Class | Value |
Total | 31029130.72 |
Less than 1 year | 11469020.73 |
Bills | 8912168.726 |
Funds | 2556852 |
Greater than 1 year | 19560109.99 |
Deposits | 19560109.99 |
HI @Anonymous,
You can create a matrix visual with class and subclass fields as row, value to value field, then power bi will auto aggregate your records based on class and subclass groups.
Create a matrix visual in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
@Anonymous , You can take class and sub class on row and expand. Only thing is that total will come below
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |