Total value is not right in Matrix table

Question

Hi all,I need some hlep to calculate the total in a matrix table. When calculte each category, the condition applied is different. When calculate "SALARIES", the [Document Type] must to be "PY", for oter category, there is no such limit. I write the measure like this:APR =VAR CurrenPeriod = CALCULATE(MAX('Date'[Period]), 'Date'[Date]=TODAY())VAR SalaryForecast = [Salary Filled Position]VAR ActualValue =IF(MAX('Rollup Master'[Rollup for Forecast Account Category])="SALARIES",CALCULATE(SUM('G/L Account'[Amount]), 'Date'[Period]=1,'G/L Account'[Document Type]="PY"),CALCULATE(SUM('G/L Account'[Amount]), 'Date'[Period]=1))RETURNIF(CurrenPeriod&gt;1, ActualValue, SalaryForecast)&nbsp;The total value 112,465 is the value without any limit. Please help how to revise the measure.&nbsp;Thank you in advance!BrankoRollup for Forecast Account CategoryAccount Rollup for Corporate ReportSum of AmountDocument TypeSALARIESSalaries72331PYSALARIESSalaries34727SASUPPLIESEmployee Travel3720ACSUPPLIESEmployee Travel-10112ADSUPPLIESEmployee Travel10278TVSUPPLIESContract Services472SASUPPLIESMaterials &amp; Supplies100ACSUPPLIESMaterials &amp; Supplies680KRSUPPLIESOther106KRSUPPLIESOther163WE&nbsp;&nbsp;

lbendlin · Accepted Answer

APR = 
var a = SUMMARIZE('Rollup Master',[Rollup for Forecast Account Category],[Account Rollup for Corporate Report],[Document Type])
var b = ADDCOLUMNS(a, "amt",CALCULATE(sum('Rollup Master'[Amount])))
return sumx(filter(b,[Document Type]="PY" || [Rollup for Forecast Account Category]&lt;&gt;"SALARIES"),[amt])
&nbsp;

Forum Discussion

Total value is not right in Matrix table

2 Replies

Related content

Totals in Matrix

Total in Matrix with values on row

Sort Column in based on the Row total values in Matrix visual

Sum totals in matrix in power bi (grand total for matrix values)

Matrix Row Totals within Row Values

Rollup for Forecast Account Category	Account Rollup for Corporate Report	Sum of Amount	Document Type
SALARIES	Salaries	72331	PY
SALARIES	Salaries	34727	SA
SUPPLIES	Employee Travel	3720	AC
SUPPLIES	Employee Travel	-10112	AD
SUPPLIES	Employee Travel	10278	TV
SUPPLIES	Contract Services	472	SA
SUPPLIES	Materials & Supplies	100	AC
SUPPLIES	Materials & Supplies	680	KR
SUPPLIES	Other	106	KR
SUPPLIES	Other	163	WE