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.