Forum Discussion

Carlo1975's avatar
Carlo1975
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity Champion
5 years ago

Carlo1975 , you might want to try

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

 

  • Carlo1975's avatar
    Carlo1975
    Icon for Helper I rankHelper I
    5 years ago

    I'm sorry, what is Cluster2?