Forum Discussion
Vendor ABC Analysis
Hi all, I am pretty new to Power BI and so far I am enjoying it, however, I am having a great difficulty in using Dax. I want to create a Vendor ABC analysis by spend and can't seem to figure out...
OK, forgive my ignorance of ABC Vendor analysis. I'm still not 100% with you. You can get each vendor's % of spend with this formula:
Percentile = DIVIDE(SUM(Vendors[Spend]),CALCULATE(SUM(Vendors[Spend]),ALL(Vendors)))
But, I get the feeling that's not exactly what you want. Let me do some searching on ABC Vendor Analysis to see if I can understand it or if you could provide details that would be cool.
here is a sample result i am expecting. I am able execute all the calculations in the table in excel 2016 and load in Power BI for visualization, however, i would like to be able to execute all the calculations using measures or other method in Power BI from my raw data rather than do the double work
Hi,
That image is just way to small. What do you have on the X-axis?
