cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## ABC Analysis

Good Evening Everyone!

I have been working over the last few weeks on creating an ABC analysis however, I am still struggling with the calculations and formulas necessary to meet the requirements of the analysis I need to get done. This is somewhat due to being unable to find tutorials that can do an ABC analysis on so many levels and still be relatively new to DAX & PowerBI.

I have attached an image below to show what I need to achieve. Any help would be much appreciated.

Many Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III

Hi,

See if my solution in this file helps.  I think some of your answers in the ABC column are wrong.  Please check my ABC column,

Regards,
Ashish Mathur
http://www.ashishmathur.com
8 REPLIES 8
Highlighted
Memorable Member

The SQLBI boys have pages about ABC Analysis on their daxpatterns site

They wrote the pages based on Excel and Powerpivot, but PowerBI uses the same model

http://www.daxpatterns.com/abc-classification/

http://www.daxpatterns.com/abc-classification-dynamic/

Highlighted
Super User III

Hi @Mack1int,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Frequent Visitor
Highlighted
Super User III

Hi,

See if my solution in this file helps.  I think some of your answers in the ABC column are wrong.  Please check my ABC column,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Frequent Visitor

Thank You so much for all of your help!

Highlighted
Helper II

Hi Ashish,

Is there a quick way to get following results using RANKX in ABC analysis?

1. Top 10% of annual cost to A
2. Between 10% and 50% of annual cost to B
3. Between 50% and 90% of annual cost to C
4. Bottom 10% of annual cost to D

Looking forward for your kind response.

Thanks & best regards,

PG

Highlighted
Super User III

Hi,

Your question is not clear.  Share some data, describe the question and show the expected result.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Helper II

Hi Ashish,

Thank you very much for your quick reponse and sorry for the delays from my side.

I have figured another way to define ABC which is working fine.

Thanks again. Have a wonderful day.

Best regards,

PG

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors