Calculate Total using DAX

[Anonymous]

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

[v-shex-msft]

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

[amitchandak]

@Anonymous , You can take class and sub class on row and expand. Only thing is that total will come below