Forum Discussion

yashwant101's avatar
yashwant101
Helper III
3 years ago
Solved

Row Aggregation in Matrix Visual

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.