Forum Discussion
Matrix table returning total for each row
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!
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:
4 Replies
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:
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!
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
Hi Anonymous ,
You could try the following DAX:
Measure 2 = SUMX ( ALLSELECTED ( 'Table'[Tier2] ), [Measure] )
