Add % Of Total Measures To Matrix

Hi DavidGlover 

Below is the data table I reduced, feel free to correct me if it differs from your data structure.

You can try to create two measures.

Divide = 
VAR _countAll = CALCULATE(COUNTROWS('Table1'), ALLEXCEPT(Table1, Table1[Site]))
VAR _count = CALCULATE(COUNTROWS('Table1'), 'Table1'[Site] = MAX([Site]), 'Table1'[Response Type] = MAX([Response Type]))
VAR _result = DIVIDE(_count, _countAll)
RETURN
_result

% = 
IF(
    HASONEVALUE('Table1'[Response Type]), 
    [Divide], 
    SUMX(ALLEXCEPT('Table1', Table1[Site]), [Divide])
)

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hello DavidGlover 

please check if this accomodate your need.

there are at least two ways.

1. Multiple measure as you mentioned above.

- create four measures for "Yes", "No", "Not Applicable", and "Total" with following DAX

Yes % = 
DIVIDE(
    SUM('Table'[Yes]),
    SUM('Table'[Total ])
)

No % = 
DIVIDE(
    SUM('Table'[No]),
    SUM('Table'[Total ])
)

Not Applicable % = 
DIVIDE(
    SUM('Table'[Not Applicable]),
    SUM('Table'[Total ])
)

Total % = 
DIVIDE(
    SUM('Table'[Total ]),
    SUM('Table'[Total ])
)

- plot those measures in matrix visual

 

2. Using Column in Matrix Value

- Unpivot your table therefor you will have category to fill in column at matrix visual

- create a new measure for calculating percent

Percent % = 
var _Attribut = SELECTEDVALUE('Table 2'[Attribute])
var _Site = SELECTEDVALUE('Table 2'[Site])
var _Max = 
CALCULATE(
    MAX('Table 2'[Value]),
    FILTER(
        ALL('Table 2'),
        'Table 2'[Site]=_Site&&
        'Table 2'[Attribute]="Total"
    )
)
var _Value = 
CALCULATE(
    MAX('Table 2'[Value]),
    FILTER(
        'Table 2',
        'Table 2'[Attribute]=_Attribut&&
        'Table 2'[Site]=_Site
    ),
    'Table 2'[Value]
)
Return
DIVIDE(
    _Value,
    _Max
)

- plot into matrix visual

 

Hope this will help.
Thank you.