Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Row percent based on row total in a matrix

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 %...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    It seems you want the % of each Total Row

     

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

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

It seems you want the % of each Total Row

 

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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