Simple Cumulative Count/Percentage Matrix

Hi sotoc,

Based on my test, you could refer to below steps:

Format the [Code] column from text to whole number.

Create two measures:

cumulative count = CALCULATE(SUM(SampleData_CumulativeMatrix[Count of Code]),FILTER(ALL('SampleData_CumulativeMatrix'),'SampleData_CumulativeMatrix'[Code]>=MAX('SampleData_CumulativeMatrix'[Code])))

cumulative% = [cumulative count]/CALCULATE(SUM(SampleData_CumulativeMatrix[Count of Code]),ALL(SampleData_CumulativeMatrix))

Result:

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/m0xv4vji1nuli6g/Simple%20Cumulative%20Count%20Percentage%20Matrix.pbix?dl=0

Regards,

Daniel He

Hi sotoc,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He