Good Evening Everyone!
I have been working over the last few weeks on creating an ABC analysis however, I am still struggling with the calculations and formulas necessary to meet the requirements of the analysis I need to get done. This is somewhat due to being unable to find tutorials that can do an ABC analysis on so many levels and still be relatively new to DAX & PowerBI.
I have attached an image below to show what I need to achieve. Any help would be much appreciated.
Solved! Go to Solution.
The SQLBI boys have pages about ABC Analysis on their daxpatterns site
They wrote the pages based on Excel and Powerpivot, but PowerBI uses the same model