Forum Discussion

fbostan1's avatar
fbostan1
Helper I
4 years ago

Help with Matrix Table

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. 

Need Help

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    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's avatar
      fbostan1
      Helper I
      4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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