Row percent based on row total in a matrix

[Anonymous]

Hello,

I have been trying to do a seemingly easy calculation, but with no success...

Below is the output of a matrix that I get in Desktop. What I want to do is to get a matrix that contains % values based on the totals of each row (so, 3/19, 14/19, 2/19  .... 11/55, 21/55, and so on).

The values inside my matrix are frequencies, i.e. the number of cases where Rows=X and Columns=Y.

I attempted using SumX with AllExcept, etc but no luck. I cannot get my formula to keep the Totals (19, 55, 18) as constants so that my division can work.

Any help much appreciated!

George

  

[Sean · Accepted solution]

It seems you want the % of each Total Row

Measure = 
DIVIDE (
    SUM ( Table1[Value] ),
    CALCULATE ( SUM ( Table1[Value] ), ALLSELECTED ( Table1[Column Field] ) ),
    0
)

[Anonymous]

Thanks a million!! It was AllSelected that I needed, not AllExcept!

[Greg_Deckler]

I believe that you want to use ALL or ALLEXCEPT like:

SUM([Column])/CALCULATE(SUM([Column]),ALL('Table'))

[BhaveshPatel]

The expected output is like this.