Press "Enter" to skip to content

Performing a Pareto Calculation in DAX

Phil Seamark does some manufacturing analysis:

I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function.

The first thing that sprung to my mind was to see how a Pareto calculation might leverage the new capability.

The basic idea of a Pareto calculation is to create a curve like representation of data ordered from largest to smallest.

Read on to see how.

2 Comments

  1. Van Decraen Roger
    Van Decraen Roger2023-04-26

    Very interesting and clearly explained , is there a PBIX we can use to practice ?

    thanks in advance

    Roger

Comments are closed.