Abc analysis

Question

Hi Guys,&nbsp;&nbsp;Has anyone done an abc anlysis in powerbi itself and not excel, such as the one shown below(probably excel), If so could you'll share the pbix file or the dax codes (need dax for running total value, 80% of running total value , etc) .&nbsp;&nbsp;Thanks&nbsp;Aj&nbsp;&nbsp;&nbsp;

chrismendoza · Answer

ajin,&nbsp;&nbsp;Have you looked at the following patterns?&nbsp;https://www.daxpatterns.com/abc-classification/

greg_deckler · Answer

I just published a dynamic ABC classification measure here:&nbsp;https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/m-p/479146#M180&nbsp;if that is helpful at all.

ajin · Answer

Hi&nbsp;ChrisMendoza&nbsp;,&nbsp;&nbsp;Thanks for responding to my query. I had reviewed this blog earlier but couldnt fully understand it as i'm new to dax. Plus isn't it used in excel?&nbsp;Thanks&nbsp;Aj

chrismendoza · Answer

The output is Power Pivot if I recall which is an addon to Excel however, it uses DAX so the pattern could be applied to BI. You'll note that Greg_Deckler actually has looked at the same document and found a potential limitation or an improvement, however you look at it, it's pretty nifty. To be honest I have yet to have a project with an ABC need so I've never looked into implementation I just knew of ABC.

Good luck in your search.

greg_deckler · Answer

ajin- If you download the PBIX attached to that Quick Measure, it has a full implementation of that DAX pattern as well as my own implementation of that pattern as a measure. Attaching it here as well. The issue is that the actual DAX is going to depend on your actual data and your actual tables. I used AdentureWorks 2014 as the basis for mine. In order to be that specific, you will need to include example/sample data as text that can be copied and pasted.&nbsp;&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Forum Discussion

Abc analysis

10 Replies

Related content

|| ABC Analysis ||

ABC Analysis

ABC analysis

Cohort analysis

How to Create a Chart Visual for ABC Analysis