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 how to. My data is very large but I have included a small sample below. Is there a tutorial somewhere I can review?

thanks for all your help. 

Date               Vendor      Item        Category             SPEND 

10/31/2017EDDD500PENCILS $    11,888.30
10/5/2017EDDD500PENCILS $    12,707.73
12/29/2016EDDD500PENCILS $    11,821.04
11/16/2016EDDD500PENCILS $    11,217.60
9/28/2016EDDD500PENCILS $      4,319.97
9/14/2016CFOVE5016BOOKS $          201.00
2/3/2017CFOVE5018BOOKS $          790.40
12/21/2017TRMF5112PAINTINGS $          395.00
10/31/2017TRMF2345PAINTINGS $          395.00
12/15/2016TRMF1298PAINTINGS $          395.00
12/15/2016TRMF5021PAINTINGS $          395.00
11/2/2016TRMF5021PAINTINGS $          395.00
6/14/2017HON5131CRAYONS $          422.40
2/22/2016HON5131CRAYONS $          140.80
5/25/2017PARK5134PENS $          925.80
5/4/2017PARK5134PENS $          925.80
12/29/2016PARK5134PENS $          925.80
12/21/2016PARK5134PENS $          925.80
7/14/2017MMCM5137CRAYONS $      5,425.00

 

 

8 Replies

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      KC1234

       

      If you want your ABC analysis to respond to filters you can use ALLSELECTED in Greg's formula

      i.e.

       

      Percentile =
DIVIDE (
    SUM ( Vendors[ SPEND ] ),
    CALCULATE ( SUM ( Vendors[ SPEND ] ), ALLSELECTED () )
)

       

    • 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.