New Matrix Column for Total Percentages

[Anonymous]

Hi All,

I've been stuck working on creating another column in my matrix chart to capture the total percentages (shown in the red). Does anyone have any suggestions on how to solve for this or where to begin with the DAX formula? Thank you in advance for your help!

Status	Group 1	Group 2	Total	Open/Closed %
Closed	75	35	110	73.33 %
Open	25	15	40	26.67%
Total	100	50	150	100 %

[FreemanZ]

hi @Anonymous ,

not sure if i fully get you, supposing you have a data table like:

Status	Group	Value
Open	Group1	25
Open	Group2	15
Closed	Group1	70
Closed	Group1	5
Closed	Group2	35

try to plot a Matrix visual with two measures like:

ValueSum = SUM(data[Value])

Open/Closed% = 
VAR _all = CALCULATE([ValueSum], ALL(data[status]))
VAR _result = DIVIDE([ValueSum], _all)
RETURN _result

it worked like: