Forum Discussion

KC1234's avatar
KC1234
Regular Visitor
8 years ago

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...
KC1234's avatar
KC1234
Regular Visitor
8 years ago

Thanks so much for your quick response Greg. What i am trying to do is develop an ABC analysis for vendors by spend such that 

ABC Analysis

A = 10% of suppliers

B = 20% of suppliers

C = 70% of suppliers

 

 

by creating either a column with each vendor classified A, B, C or using a measure and be able to graph it. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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.

 

 

  • KC1234's avatar
    KC1234
    Regular Visitor
    8 years ago

    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 

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      That image is just way to small.  What do you have on the X-axis?