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
Icon for Super User rankSuper User
8 years ago

Hi,

 

Please show the exact result which you are expecting.

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity 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 () )
)