Power BI and Azure Data Platform

ABC Classification DAX pattern

ABC analysis is an inventory categorization technique, with conceptual similiarity to Pareto analysis - see Wikipedia article

ABC Classification explained on DAX patterns site

• Basic pattern example

  This uses several calculated columns in the Products table.

• Complete pattern example

  The template solution uses these generic values: <granularity_table>, <granularity_attribute> and <measure>.

  [EntityMeasure] = CALCULATE ( <measure> )
   
  [CumulatedPercentage] = CALCULATE (
    <measure>,
    ALL ( <granularity_table> ),
    <granularity_table>[EntityMeasure]
        >= EARLIER ( <granularity_table>[EntityMeasure] )
      )
    / CALCULATE ( <measure>, ALL ( <granularity_table> ) )
   
   [ABC Class] = SWITCH (
    TRUE (),
    <granularity_table>[CumulatedPercentage] <= 0.7, "A",
    <granularity_table>[CumulatedPercentage] <= 0.9, "B",
    "C"
  )
  

Return to:

Top

Back to static Segmentation DAX pattern

Back to overview of DAX patterns

Home