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. I created a measure for max of Stores but the rows section won't accept a measure.

 

Any help is highly appreciated.

 

Regards,

Yashwant

 

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.

1 Reply

  • 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.