Carlo1975Helper I5 years agoSolvedMatrix 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 ...Show MoreCNENFRNL5 years agoCarlo1975 , you might want to try% Accum = VAR __gt = SUMX ( ALL ( Table1[Cluster2], Table1[Quarter] ), [Accum] ) RETURN DIVIDE ( [Accum], __gt )
CNENFRNL5 years agoCarlo1975 , you might want to try% Accum = VAR __gt = SUMX ( ALL ( Table1[Cluster2], Table1[Quarter] ), [Accum] ) RETURN DIVIDE ( [Accum], __gt )
CNENFRNL5 years agoCarlo1975 , you might want to try% Accum = VAR __gt = SUMX ( ALL ( Table1[Cluster2], Table1[Quarter] ), [Accum] ) RETURN DIVIDE ( [Accum], __gt )
CNENFRNLCommunity Champion5 years agoCarlo1975 , you might want to try% Accum = VAR __gt = SUMX ( ALL ( Table1[Cluster2], Table1[Quarter] ), [Accum] ) RETURN DIVIDE ( [Accum], __gt )
Related contentMatrix tableMatrix tableKPI level matrix tableMatrix table in Power biPowerBI - Matrix table, hide values used only for a visual calculation
