Forum Discussion

Carlo1975's avatar
Carlo1975
Helper I
5 years ago
Solved

Matrix table with sum

Hi, I have a problem and I don't know how to overcome it. I don't know if the solution is Dax or power query. I'm sorry. I try to explain.   I have a table like this. With 2 clusters columns, one ...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Carlo1975 , you might want to try

    % Accum =
VAR __gt = SUMX ( ALL ( Table1[Cluster2], Table1[Quarter] ), [Accum] )
RETURN
    DIVIDE ( [Accum], __gt )

     

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, Carlo1975 , do you expect this?

You might want to add another measure,

% Accum = 
DIVIDE( [Accum], CALCULATE( SUM( Table1[Amount] ) , ALL( Table1[Quarter] ) ) )
  • Carlo1975's avatar
    Carlo1975
    Helper I
    5 years ago

    HI CNENFRNL and Thank you....with this I obtain always 100% on my chart, instead I have to have this:

     

     

    And so each percentage, is a percentage on the grand total (4.190)...the sum of all the percentage will be 100%

     

    150 is the 4% of grand total 4.190

    300 is the 7% of grand total 4.190

     

    I hope to explain well my problem.

    thank you

    Carlo