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...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Please show the exact result which you are expecting.

  • 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 () )
)