Help with Matrix Table

[fbostan1]

Hi,

Any help with this, I would really apprecaite it.

I have this 3 Matrix table 

I want to get the percentage of the two numbers highlighted in yellow in another matrix table right under this one. 

any quick way to do this? for the first matrix, Rows is from a table 'GIACT_CODE_DESC'[MESSAGE_FOR_OPS], Columns  is from DimDate Table and Values is from Table 'Submitted_Policies'[POLICY_NUM] and same with the third Matrix. 

[Anonymous]

HI @fbostan1,

You can't directly calculate across different visuals, they have particular row context based on filter effects.
If you want to calculate these differences, you need to manually aggregate records with similar filter effects and category groups to restore corresponding row context to calculate with the current expressison.

Row context in DAX - SQLBI

All the secrets of SUMMARIZE - SQLBI

Regards,

Xiaoxin Sheng

[PaulDBrown]

Assumin the values displayed are the measure [Values]

Try 

% over all Message_for_ops =
VAR _All =
    CALCULATE ( [Values], ALL ( Table[MESSAGE_FOR_OPS] ) )
RETURN
    DIVIDE ( [Values], _ALL )

[fbostan1]

I figured that part out, I just updated my question.