Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

New Matrix Column for Total Percentages

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!

 

StatusGroup 1Group 2TotalOpen/Closed %
Closed753511073.33 %
Open251540 26.67%
Total10050150100 %
DAX
Desktop
percentages

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    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: