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.

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

No they arent. Those columns are produced with the matrice. So what I really what to know is as I mentioned. If it is possible to calculate Y/X for example. With the columns produced by the matrice directly or I'd have to go another sort of roundabout way

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

kitala11 , New column

divide([Y],[X])

is that giving problem.

 

X and Y should be columns, If they are measures, new column is not possible