Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
foyiq
Advocate I
Advocate I

Matrix Table Total Row not calculating totals

Dears,


I have come across a similar problem as the one described
here, but couldn't apply this to fix my case. I have a following matrix:
 05.07.png

I want the highlighted column total to simply add up all the rows, which would give 3594.79 in this case.

the measures I use here are:

ДЗ вх. = sum('Sales(UnP)'[Объем, т]) * '01_Measures'[Цена (2)] * '01_Measures'[Отсрочка ДЗ] / sum(Dates[DaysQ])/1000

Отсрочка ДЗ = CALCULATE(AVERAGE('Incurred2(UnP)'[Прошлая отсрочка]); FILTER('Incurred2(UnP)';'Incurred2(UnP)'[Код позиции] = "2005/11103" || 'Incurred2(UnP)'[Код позиции] = "2005/1110909"); 'Incurred2(UnP)'[Тип обязательства]="Продажи")

Цена (2) = 
SUMX('Sales2(UnP)'; 'Sales2(UnP)'[Цена] * 
	Calculate(
		Values(
		'Sales(UnP)'[Объем, т]);
		Filter('Sales(UnP)';
			'Sales(UnP)'[Группа продукции]='Sales2(UnP)'[Группа продукции] &&
			'Sales(UnP)'[Контрагент]='Sales2(UnP)'[Контрагент])))
/sum('Sales(UnP)'[Объем, т])

DaysQ calculates the no. of days in a chosen period. 

I suppose the problem is in the formula for the main measure itself.

How should I change the formula to get the simple sum, not in total row context?

Thank you beforehand.

 

Regards,

Foyiq

1 ACCEPTED SOLUTION
foyiq
Advocate I
Advocate I

the solution was quite simple, guys, in the measure, the partial SUM had to be changed to full SUMX. Piece of cake for everyone, but took me a day to realize the mistake))

View solution in original post

1 REPLY 1
foyiq
Advocate I
Advocate I

the solution was quite simple, guys, in the measure, the partial SUM had to be changed to full SUMX. Piece of cake for everyone, but took me a day to realize the mistake))

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.