Dividing values from 1 matrix with values of another matrix

[Pragati]

I need to divide each value in first matrix with the value in second matrix for each monthThis is the desired output which I am trying to replicate in powerBI

I have used 3 slicers on matrix 1 - Severity, STS , 66 Customer from one dataset

In Matrix 1:

In Rows       :    Severity (Major , Minor, Information)

In Columns  :    Month

In Values      :    Count of 66 Customer Column

In Matrix 2 :

I have used 1 slicer - 66 Customer from another data set

In Rows           :  -

In Columns     : Month1

In Values         : Count of 66 Customer1

[v-yulgu-msft]

Hi @Pragati,

Generally speaking, it is not available to do calculation between two unrelated matrix. Are these values in Matrix1 and Matrix2 coming from a single table or two related tables?

I need your source table structure and more detailed data so that I can test. Also, I noticed there are three rows in Matrix1, while there is only one row in Matrix2, then, how to divide?

Regards,
Yuliana Gu