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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.