SUM of matrix columns Total Current

[rafaelprog]

I have the following matrix

I'm trying to make the sum of the months

But when I add the measure "total current in period", it creates a column for each Month!

Total Current In Period = 
CALCULATE(
	SUM('AGG_INFOGER_CTR'[Total]);
	FILTER(
		CALCULATETABLE(
			SUMMARIZE(
				'DIM_PERIODO';
				'DIM_PERIODO'[Itemperiodo];
				'DIM_PERIODO'[Period]
			);
			ALLSELECTED('DIM_PERIODO')
		);
		ISONORAFTER(
			'DIM_PERIODO'[Itemperiodo]; MAX('DIM_PERIODO'[Itemperiodo]); DESC;
			'DIM_PERIODO'[Period]; MAX('DIM_PERIODO'[Period]);
		)
	)
)

The calculation is not wrong but I just wanted the summation of the last column!

Current total in the context of the row

Example:


What would be a dax function?  I am a beginner
Thanks!

[v-yuezhe-msft · Accepted solution]

@rafaelprog,

The issue has nothing to do with DAX. No matter what additional column or measure you add in Value section of the Matrix visual, it will create a column for each month, and it is not possible to show only the last column.

In your scenario, does it return your expected result when you just reserve Total field in the Value section and turn on “Total column”?

Regards,
Lydia Zhang

[rafaelprog]

It Worked, Thanks

[v-yuezhe-msft]

@rafaelprog,

Glad to hear the issue is solved, please mark my reply as answer, that way, other community members would easily find the answer when they get same issues.

Regards,