Forum Discussion

kitala11's avatar
kitala11
Icon for Helper III rankHelper III
5 years ago
Solved

Matrices

X    Y 1     2 3     4 5     6   Does anyone know if there is a way to use the columns of the matrices. For example using Y to divide X, and get a third column?
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi kitala11 ,

    You can use columns in Matrix visual to carry on division by creating three Measure.

     

    In the sample, there are item, X, and Y columns in a table called matrix. They are used to build Matrix visual.

     

    Three Measure:

    MX = SUM(matrix[X])

    MY = SUM(matrix[Y])

    divide = matrix[MY]/matrix[MX]

     

    The result looks like this:

     

     

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi kitala11 ,

You can use columns in Matrix visual to carry on division by creating three Measure.

 

In the sample, there are item, X, and Y columns in a table called matrix. They are used to build Matrix visual.

 

Three Measure:

MX = SUM(matrix[X])

MY = SUM(matrix[Y])

divide = matrix[MY]/matrix[MX]

 

The result looks like this:

 

 

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.