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.
Very interesting and clearly explained , is there a PBIX we can use to practice ?
thanks in advance
Roger
Hi, Roger. It looks like Phil does not have anything directly associated with that post, though the DAX sample model at https://learn.microsoft.com/en-us/dax/dax-sample-model is based on AdventureWorksDW, which appears to be the data model Phil used.