Matrix table returning total for each row

[Anonymous]

Hi everyone, 

A year ago I created a formula, the [Closed] is a measure: 

The main goal was to aggregate the total numbers for each item, second column: 

For some reason, I want to use the source table's column from now on, but I am not able to deliver the same, I tried everything variables all of the sum and filtering options, but always returning the non-aggregated values

Is it possible to returning totals for each row without measure at all? 

Thank you!

[Anonymous · Accepted solution]

So, I found the solution and it was totally understandable why the aggregation didn't work, In the matrix table's rows section there were 2 groups: 

Since the calculation did not contain the [Related assignment group] field, the calc has failed to work. So I eliminated the mentioned field and voila: 

The only issue that I have to eliminate the rows without value and this is possible with an ISINSCOPE function, so here is the right calculation: 

[v-eachen-msft]

Hi @Anonymous ,

I am glad that you have found the solution by yourself. You could accept your own reply to help the other members find it more quickly. Thank you for your contribution!

[v-eachen-msft]

Hi @Anonymous ,

You could try the following DAX:

Measure 2 =
SUMX ( ALLSELECTED ( 'Table'[Tier2] ), [Measure] )

[Greg_Deckler]

Well, you could create a new column in your table that would have the total but generally no, there is no Count ALL default aggregation