Chetan007Frequent Visitor1 year agoSolvedHow to Create Matrix Table with percentage TotalData: Output:How to Solve this problem!!danextian1 year agoHi Chetan007 Try this: DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Subgroup] ) ) ) That will look something like below: If this doesn't work, please post a sample data that can be copy-pasted to Excel and not an image.
danextian1 year agoHi Chetan007 Try this: DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Subgroup] ) ) ) That will look something like below: If this doesn't work, please post a sample data that can be copy-pasted to Excel and not an image.
danextian1 year agoHi Chetan007 Try this: DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Subgroup] ) ) ) That will look something like below: If this doesn't work, please post a sample data that can be copy-pasted to Excel and not an image.
1 ReplyReplies sorted by Most LikeddanextianSuper User1 year agoHi Chetan007 Try this: DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Subgroup] ) ) ) That will look something like below: If this doesn't work, please post a sample data that can be copy-pasted to Excel and not an image.
danextianSuper User1 year agoHi Chetan007 Try this: DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Subgroup] ) ) ) That will look something like below: If this doesn't work, please post a sample data that can be copy-pasted to Excel and not an image.
Related contentCreate a matrix visual showing percentagesCreating cumulative percentagePercentage of parent total in matrix visualShow percentage on matrix.Percentage of Total in Matrix
