Skip to main content

Power BI

New

Create Pareto, Quartile, Quintile, Decile Groups from data

Vote (37) Share
's profile image

on 13 Apr 2017 07:39:13

To do Pareto analysis of data you need to use RankX, Create a cumulative sum of the list (TopN), then divide the cumulative sum at the row by the grand total of the column. the resulting output is the % the running sum is of the grand total. From there you filter to show top x%.

However, couldn't this process streamlined into custom calculation and while we are at it, why not allow the data to be grouped in Quartiles, Quintiles and Deciles.