Row Aggregation in Matrix Visual

[yashwant101]

Hi all,

I have a matrix visualisation wher I need to put Stores(numerical field) in the rows section. 

The issue is that it is taking the individual values in Stores rather than summarized. I created a measure for max of Stores but the rows section won't accept a measure.

Any help is highly appreciated.

Regards,

Yashwant

[v-binbinyu-msft · Accepted solution]

Hi @yashwant101 ,

Please try to create a new column firstly, then add it into Matrix row.

Please try below steps:

1. below is my test table

Table:

2. create a new column with below dax formula

Sum_score =
VAR a = [Outlet]
VAR tmp =
    FILTER ( 'Table', [Outlet] = a )
VAR val =
    SUMX ( tmp, [Stores] )
RETURN
    val

3. add a matrix visual with table fields

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.